Skip to main content Skip to complementary content

Defining parsing rules to standardize data


  1. Double-click tStandardizeRow to display the component Basic settings view.
    This component helps you to define the rules necessary to standardize the unstructured input flow and generates the brand, range, color and unit in XML format.
  2. From the Column to parse list, select Long_Description.
  3. Select the Standardize this field check box.
  4. Define your rules as the following:
    1. In the Conversion rules table, click on the [+] button to add the columns necessary to define the rules.

      This scenario focuses on the rules of the type Index. For detail examples about the other rule types defined in the capture above, please refer to the other tStandardizeRow scenarios.

    2. Define three rules as Brand, Range and Color.
    3. From the Type list, select Index and fill in the Value field with the context variable of the indexes you generated.
      For further information about how to create and use context variables, see Using contexts and variables.
    4. From the Search mode list, select Match exact. Search modes are only applicable to the Index rules.

      Using the Match exact mode, you will extract from the input flow only the strings that exactly match the brand, range, and color index strings you generated with the tSynonymOutput component. For further information about available search modes, see Search modes for Index rules

  5. Click the Generate parser code in Routines button in order to generate the code under the Routines folder in the DQ Repository tree view of the Profiling perspective.
    This step is mandatory, otherwise the Job will not be executed.
  6. In the Advanced settings view, leave the options selected by default in the Output format area as they are.
    The Max edits for fuzzy match is set to 1 by default.
  7. Double-click tLogRow and define the component settings in the Basic settings view.
  8. In the Mode area, select the Table (print values in cells of a table) option.
    This component displays the tokens from the input flow that could not be analysed and matched to any of the index strings.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!