Expanding on keyword expansion

Don't miss that when you are running keyword expansion from the Document tab in Relativity, you can expand on a kewyord in the in conceptual keywords expansion window.

After selecting a conceptual analytics index when running an index search, an Expand link will appear in the search window:

If you click on Expand, the keyword expansion window will open. When you enter a term in this window, assuming the term is included in the index's training data source, Relativity will show other terms correlated to your term in its spatial index. Words with a coherence score of 50 or greater may be returned.

In this example the keyword 'enron' is shown to be closely related to five other terms within the text of the documents used to train the analytics index. When we click on the word 'baxter' in this list, the keyword expansion list will update to show the keyword terms that are correlated to in the analytics index.

You can check off terms and then use the 'Copy Selected Keywords' button at the bottom of the window to generate a Boolean search to use in an Index Search.

You can add or remove filters on the search results. If you want to filter by a number range in the Rank field, use >= OR <= . > OR < by themselves will result in a syntax error.

This screen grab shows the process in action.

Stopping Excel from rounding off long numbers during import

The Tip of the Night for March 24, 2023, warned about Excel's tendency to cut off numbers with multiple decimal places. Excel will also round up whole numbers with many digits when files are imported into Excel. Here's some additional information on how you can import whole numbers into Excel from .csv files without having Excel round them up and

When importing .csv files into Excel from the Data tab on the ribbon using the From Text/CSV import tool, you will be prompted to detect the data type. By default Excel will base the format on the first 200 rows. In a field with a number with more than 11 digits, Excel will switch the format to scientific notation:

If you except the default settings, load the data, and then reformat the cells to display the whole number, you'll see all of the numbers have been rounded up and will end in zero.

You can avoid this problem when importing the .csv file by resetting the Data Type Detection to 'Do not detect data types'

. . . the file will import into an Excel worksheet with the numbers intact:

set regex filters in Relativity structured analytics sets for pipeline text

Keep in mind that when you set a regular expression filter for a structured analytics set in Relativity, the regex filter will not be run against the extracted text as you can see it for a document in the Viewer. While the extracted text is displayed with line breaks and whitespace, this text is transformed when it is in the Analytics pipeline. The pipeline text uses the regex \r\n markers [return and newline] in place of line breaks, and will consolidate multiple blank spaces to a single space.

Extracted text may look like this:

. . . but the pipeline text will look like this:

There's just one long string of text in the analytics pipeline. So if you want to search for an email footer reading, "Under the General Data Protection Regulation GDPR 2016 679 we have a legal duty to protect any information we collect from you", accounting for varying GDPR sections, a regex filter for a structured analytics set . . .

. . . should be set like this:

. . . without the additional spaces before and after the relevant GDPR section.

If you want to filter out multiple disclaimers added to email footers, and Bates numbers from more than one party's production, you'll need to craft a single regex search which can account for all these targeted terms. No more than one regex filter can be applied to a structured analytics set.