Fine-tuning the Properties Columns

  1. Click Edit Table in the Stream Table.
  2. Hover over the 'Properties' column heading that you want  to filter or transform, click on the down arrow and then the Fine-tune icon Fine-tune_icon.ico to display the Property Fine-tune dialog box.
    Fine-tune_Xform_Filter_DB.png
  3. Click Choose.
  4. i. To Transform a Property, select

ChangeCase

Change case of input string to all lower or all upper case

Prefix

Extract prefix of defined length

Replace

Finds a ‘target’ substring and replaces it was ‘replacement’

Suffix

Extract suffix of defined length

Remove

Remove the string between the Prefix and Suffix. Prefix and Suffix are defined by Regex

Extract

Extract the string between the Prefix and Suffix. Prefix and Suffix are defined by Regex

ii. To Filter a Property, select

Starts with

To include values that start with the specified prefix, use * as wildcard

Does not start with

To include values that do not start with the specified prefix, use * as wild card

Ends with

To include values that end with the specified suffix, use * as wildcard

Does not end with

To include values that do not end with the specified suffix, use * as wild card

Equals

To include values that are equal to the specified text

Contains

To include values that contain the specified text, use * as wildcard

Does not Contain

To include values that do not contain the specified text, use * as wildcard

Matches Regex

To include values that match the specified Regex

Does not Match Regex

To include values that  do not match the specified Regex

Note
• If requested, select Yes/No Ignore case.
• To add more Filters and/or Transformers, click the Plus icon. .
• Filters and Transformations will work in the order they are presented.

5. Click APPLY.
6. Repeat steps 2 to 5 to change other Properties.
7.  Click Stream It to stream the filtered and  transformed data into Anodot for processing.

BEFORE clicking Stream It, check that you’ve finished fine-tuning the Stream Table. Streaming will take a few moments - how long depends on your system and the amount of data to be processed.

To view the metrics created, navigate to the Anodot Metrics window.

See
Editing a Stream Table
Editing 'What' Columns
Adding New Columns

 

 

Was this article helpful?
0 out of 0 found this helpful