Recoding Data Using Multiple Attributes - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

When you create an entity-based or file-based recode table, you can match up to five (5) attributes against the original value for the recode to take place. This creates an AND condition for the recode operation. The Transformer combines the multiple attributes in the recode table into a string, and then tries to find that string in the combined attributes in the output. You can then recode up to five attributes in the output.

Note: Specifying multiple match attributes does not create separate recodes. You cannot recode multiple attributes individually in a single table recode operation. To do so, you will need to create separate table recodes in the Transformer.

The number of attributes that you look up does not have to be the same as the number of attributes that you recode. For example, you could look up three attributes and recode two attributes.

Note: The attribute names used in the table do not have to be the same as the attribute names used in the data.

Recode Table

Brand

Make Model Code Discount
X A 1 AB9 10
Y B 2 CD8 20
Z C 3 EF7 30

Before Recode

Row #

Brand

Make Model Code Discount
1 X A 1 ZZ1 5
2 Y C 2 YY2 10
3 Z C 3 XX3 15

Configure a Table Recode where the look-up attributes are Brand, Make and Model and the recode attributes are Code and Discount. The Transformer combines the Brand, Make, and Model attributes into a string (for example, 'X' + 'A' + '1' = "XA1") and looks for that string in the combined attributes in the output. In this example, Row # 1 (XA1) and #3 (ZC3) are matches and they receive the recode values in the Code and Discount attributes.

After Recode

Row #

Brand

Make Model Code Discount  
1 X A 1 AB9 10 < match found so Code and Discount change
2 Y C 2 YY2 10 < no match found so no change
3 Z C 3 EF7 30 < match found so Code and Discount change