August 15, 2023

Configuring the process of normalizing rows – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the process of normalizing rows – Docs for ESB 6.x

Configuring the process of normalizing rows

To do this, proceed as follows:

  1. Double-click tStandardizeRow to open
    its Component view.

    Use_Case_tStandardizeRow3.png

  2. In the Column to parse field, select
    SKU_Description_Size_Weight. This is the only
    column that the incoming schema has.
  3. Under the Conversion rules table,
    click the plus button eight times to add eight rows in this
    table.
  4. To complete these rows, type in the rules you have figured out when
    analyzing the raw data at the beginning of this scenario.

    The two Size rules are executed in top-down
    order. In this example, this order allows this component to match
    firstly the sizes with three numbers and then those with two numbers. If
    you reverse this order, this component will match the first two numbers
    of all sizes before all and then treat the last number of the
    three-numbers sizes as unmatched.
  5. Click the Generate parser code in
    routines     button.
  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.
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