Discussion Board for collaboration on QlikView Scripting.
I have a problem with a new definition of table.
I have this table
Tmp:LOAD * INLINE [ Key, Value A, 10 A, 11 B, 10 B, 11 B, 12];
LOAD * INLINE [
and I want to obtain this risult:
Key ValueA 10,11B 10,11,12
Can anyone help me?
Go to Solution.
LOAD Key, concat(Value,',') as value_new Resident Tmp group by Key;
output like this
Load Key,Concate(Value,',') as New_Value
Resident Tmp Group by Key;
then u have to concat the value
concat(distinct value.'') as value1,
concat(distinct key .'') as key1