Skip to main content
Version: 0.18.3

Search

Search lets you search the columns in a specific dataset or across all datasets and find the ones containing rows with data that fits certain criteria. For example, you could return all of the columns in all of your datasets that have rows that look like a phone number or an email address or contain values within or outside of a given range.

Format

Search has many utterances:

  • Search all columns in all datasets for matches to <string>
  • Search all columns in all datasets for values that look like a <pattern>
  • Search all columns in the dataset <dataset name> for values that look like a <pattern>
  • Search all numeric columns in all datasets where the value is <predicate>
  • Search all numeric columns in the dataset <dataset name> where the value is <predicate>
  • Search all string columns in all datasets for matches to <string>
  • Search all string columns in all datasets for values that look like a <pattern>
  • Search all string columns in the dataset <dataset name> for matches to <string>
  • Search all string columns in the dataset <dataset name> for values that look like a <pattern>

Parameters

Search uses the following parameters:

  • string. The string to match with.
  • pattern. The pattern to match with. By default, the options are phone numbers, email addresses, and URL. You can also create your own using Define.
  • predicate. Operators used to compare two values, including:
    • is (not) between the values <value 1> to <value 2>
    • is (equal to/not equal to/greater than/greater than or equal to/less than/less than or equal to) the aggregate value <aggregation>. Refer to Compute for more information about aggregations.
    • is (equal to/not equal to/greater than/greater than or equal to/less than/less than or equal to) the column <column>
    • is (equal to/not equal to/greater than/greater than or equal to/less than/less than or equal to) to the math expression <expression>. Refer to Drop for more information about expressions.
    • is (equal to/not equal to/greater than/greater than or equal to/less than/less than or equal to) to the value <value>
    • is (not) null
    • is (not) one of <value>
  • dataset name. The name of the dataset to search.

Output

If any matching columns and rows are found, they're returned as a separate dataset that lists the column name, the dataset containing the column, the value that was found, and a score indicating the strength of the match (higher is better). A success message is also returned in the chat history.

Otherwise, an error message is returned.

Examples

To search for all of the columns and rows in all of your datasets that contained the word "Boston", enter Search all columns in all datasets for matches to boston.

To search for the columns and rows in the dataset called "LaptopList" with values between 256 and 1024, enter Search all columns in the dataset LaptopList where the value is between 256 to 1024.

To search for the columns and rows in all of your datasets that looked like a phone number, enter Search all columns in all datasets for values that look like a USPhoneNumber.