August 15, 2023

Defining parsing rules to standardize data – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Defining parsing rules to standardize data – Docs for ESB 6.x

Defining parsing rules to standardize data

  1. Double-click tStandardizeRow to display
    the component Basic settings view.

    use_case-tstandardizerow-index_rules5.png

    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 informastion about how to create and use context
      variables, see
      Talend Studio User Guide      .
    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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x