Discussion Board for collaboration on QlikView Scripting.
In my model i have two fields:
Values in field Id is unique, but there may be several Names for one Id.
How in load script to concat Names for every Id, if count(Name)>0 for one Id?
1 Name1_First & Name1_Second
There're model and source file in attachment
Go to Solution.
Concat(Name,' & ') as Name
group by ID;
Concat(Name, ' ') as "Name"
Group by Id;
Thanks! Good work
new table: Load field1, concat(field2,’-’)as concatlist