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 where members can learn more about Qlik Sense App Development and Usage.
i have 3 values and i want to combine these 3 without repeat
The 3 values are John, George and Paul (sorry Ringo 😉 )
That is the result I want to have
John George Paul
What algorithm could create this result? I tried karthesian product, but this causes repeats , for example
and so on.
I really would appriciate a hint!
May be this
LOAD * INLINE [
Left Join (Table)
LOAD Name1 as Name2
LOAD Name1 as Name3
CrossTable (Header, Name)
LOAD RowNo() as RowNum,
LOAD Distinct Name;
Concat(DISTINCT Name, ',') as Name
Group By RowNum;
DROP Table Table, TempTable;
View solution in original post
What a clever use of crosstable!
Hahaha yes, I am glad we were able to figure it out using CrossTable()