Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Pivot Data Strings Per ID

Hi, I have been stuck on this query for a while looking to see if anyone has any ideas on how to do this?

I have a long data set that looks similar to this 

interation_ID Name leg_ID
1000001 John 1
1000001 Jack 2
1000001 Jeff 3
1000001 July 4
1000002 Jack 1
1000002 Alex 2
1000003 Rachel 3
1000003 Chris 4
1000003 Simon 5
1000003 Toby 6
1000003 Joy 7
1000003 Ryan 8
1000003 James 9


As i now need to build a sankey chart i am trying to get the dataset to be wide as opposed to long. IE 

1000001 John Jack Jeff July      
1000002 Jack Alex          
1000003 Rachel Chris Simon Toby Joy Ryan James
Labels (3)
1 Reply

Have a look at solutions using Generic Load and then table concatenation:


Or loop-based solutions that don't use Generic Load: