Discussion Board for collaboration on QlikView Scripting.
I am struggling with the following need within a Qlikview script:
I have an input table with 2 columns. Column1 has a ID (Pack ID), column 2 a text. During load I need to to dynamically create a table that:
- unique IDs
- concatenates the text (with "+" separator") if the Pack_ID is same.
- concatenated items need to be acendingly sorted.
I have the feeling I need to use Peek function, use variables and possibly a variable.
Any input much appreciated.
Go to Solution.
LOAD [Pack ID],
(ooxml, embedded labels, table is Sheet1);
Concat(Content,'+') as Value
Group By [Pack ID]
drop table T1;
updated the syntax
View solution in original post
Example file attached
Thanks for the script.
Works as needed !
Please close this thread by marking a correct answer