Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use tNormalize to split the ProductSKU on multiple rows.
Use tNormalize to split the ProductSKU on multiple rows.