Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a raw data which is been spited by its item ID, Customer name, Country, etc.
Example if any cell row have: India, USA, Africa
This country is spited in different rows:
India
USA
Africa
I would like to merge all this multiple entries in to single row. Please find attached file with 2 sheets.
There is no Cell row for all Strings which you want to split in sample?
Try this
Table:
LOAD [Item ID],
Concat([Customer Name], ', ') as [Customer Name],
Concat(Counry, ', ') as Counry,
Package,
Concat([Item Number], ', ') as [Item Number],
[PASS/FAIL]
FROM
[..\..\Downloads\Qlik_Question.xlsx]
(ooxml, embedded labels, table is [Raw Data])
Group By [Item ID], Package, [PASS/FAIL];