Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Join in tMap with row having comma separated values.

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 :

0683p000009M1X9.jpgTable 2
0683p000009M1Wc.jpgTable 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

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Use tNormalize to split the ProductSKU on multiple rows.

View solution in original post

2 Replies
TRF
Champion II
Champion II

Use tNormalize to split the ProductSKU on multiple rows.

Anonymous
Not applicable
Author

@TRF

 

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