Many to Many lookups help.

Anonymous — Fri, 19 Apr 2019 23:08:05 GMT

Hi,

Could you please tell how to lookup two files based on column "ParentID" and get out as below:

Consider a sample input file1 as below, which has two ParentID's:

ParentID,UserTypeID,AttributeID,Value
"9197741","ProductLine","ATT_Industry","Heavy Equipment"
"9197741","ProductLine","ATT_Industry","Transportation"
"9547005","ProductLine","ATT_Industry","Furniture"
"9547005","ProductLine","ATT_Industry","Kitchen Cabinetry"
"9547005","ProductLine","ATT_Industry","Interior Building Products"

Consider another sample file2 which has 3 SKU .
SKU_ID,UserTypeID,ParentID
"9205295","SKU","9197741"
"501247241","SKU","9547005"
"501247233","SKU","9547005"

Output:

For each row in file1 :
For each SKU_ID in file 2 which has a ParentID in file1 , get 'value' from file1 and SKU_ID from file2.

SKU_ID, Value
9205295,"Heavy Equipment"
9205295,"Transportation"
501247241,"Furniture"
501247241,"Kitchen Cabinetry"
501247241,"Interior Building Products"
501247233,"Furniture"
501247233,"Kitchen Cabinetry"
501247233,"Interior Building Products"

Re: Many to Many lookups help.

akumar2301 — Fri, 19 Apr 2019 23:41:17 GMT

Inner join should work in tmap.

Re: Many to Many lookups help.

Anonymous — Wed, 24 Apr 2019 15:13:14 GMT

Inner join with match model -All rows worked.

Thank you!

topic Many to Many lookups help. in Talend Studio

Many to Many lookups help.

Re: Many to Many lookups help.

Re: Many to Many lookups help.