This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
LOAD Key, concat(Value,',') as value_new Resident Tmp group by Key;
output like this
View solution in original post
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