Many to Many lookups help.

[Anonymous]

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"

[akumar2301]

Inner join should work in tmap.

[Anonymous · Accepted solution]

Inner join with match model -All rows worked.

Thank you!