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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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