Join in tMap with row having comma separated values.

Anonymous — Wed, 21 Nov 2018 08:26:06 GMT

I have to outputs
ONE contains attributes : 'ProductSKU' and 'LocationID'.(contains only one value in a each row).
SECOND contains attributes : 'ProductSKU', 'ProductCode', 'ProductName' and 'LocationID'.(contains multiple values with comma separated in each row)
Screenshot attached below :

Table 2
Table 1

Now i want to MAP or JOIN, Table_1.ProductSKU to Table_2.ProductSKU

for exmaple
Table_1 contains 'QDE' the it should map with Table_2 'QDE' of "QD,Q1D,QDE", which is comma separated and results be like

Expected Outcome :
ProductSKU | ProductName | LocationID

'QDE' | 'Queen Deluxe' | 'AHM'

How can i achieve this in tMap??
Note: Table_2.ProductSKU.contains(Table_1.ProductSKU) doesn't works for this model

Re: Join in tMap with row having comma separated values.

TRF — Wed, 21 Nov 2018 11:45:49 GMT

Use tNormalize to split the ProductSKU on multiple rows.

Re: Join in tMap with row having comma separated values.

Anonymous — Wed, 21 Nov 2018 12:22:56 GMT

@TRF

Thank you so much, that works for me very well
Regards
Meet Mahajan

topic Re: Join in tMap with row having comma separated values. in Talend Studio

Join in tMap with row having comma separated values.

Re: Join in tMap with row having comma separated values.

Re: Join in tMap with row having comma separated values.