topic Pivot Data Strings Per ID in App Development https://community.qlik.com/t5/App-Development/Pivot-Data-Strings-Per-ID/m-p/1868121#M71687 <P>Hi, I have been stuck on this query for a while looking to see if anyone has any ideas on how to do this?</P> <P>I have a long data set that looks similar to this&nbsp;</P> <TABLE width="254"> <TBODY> <TR> <TD width="126">interation_ID</TD> <TD width="64">Name</TD> <TD width="64">leg_ID</TD> </TR> <TR> <TD>1000001</TD> <TD>John</TD> <TD>1</TD> </TR> <TR> <TD>1000001</TD> <TD>Jack</TD> <TD>2</TD> </TR> <TR> <TD>1000001</TD> <TD>Jeff</TD> <TD>3</TD> </TR> <TR> <TD>1000001</TD> <TD>July</TD> <TD>4</TD> </TR> <TR> <TD>1000002</TD> <TD>Jack</TD> <TD>1</TD> </TR> <TR> <TD>1000002</TD> <TD>Alex</TD> <TD>2</TD> </TR> <TR> <TD>1000003</TD> <TD>Rachel</TD> <TD>3</TD> </TR> <TR> <TD>1000003</TD> <TD>Chris</TD> <TD>4</TD> </TR> <TR> <TD>1000003</TD> <TD>Simon</TD> <TD>5</TD> </TR> <TR> <TD>1000003</TD> <TD>Toby</TD> <TD>6</TD> </TR> <TR> <TD>1000003</TD> <TD>Joy</TD> <TD>7</TD> </TR> <TR> <TD>1000003</TD> <TD>Ryan</TD> <TD>8</TD> </TR> <TR> <TD>1000003</TD> <TD>James</TD> <TD>9</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>As i now need to build a sankey chart i am trying to get the dataset to be wide as opposed to long. IE&nbsp;</P> <TABLE width="574"> <TBODY> <TR> <TD width="126">1000001</TD> <TD width="64">John</TD> <TD width="64">Jack</TD> <TD width="64">Jeff</TD> <TD width="64">July</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> </TR> <TR> <TD>1000002</TD> <TD>Jack</TD> <TD>Alex</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>1000003</TD> <TD>Rachel</TD> <TD>Chris</TD> <TD>Simon</TD> <TD>Toby</TD> <TD>Joy</TD> <TD>Ryan</TD> <TD>James</TD> </TR> </TBODY> </TABLE> Sat, 16 Nov 2024 16:53:13 GMT Rogers2212 2024-11-16T16:53:13Z Pivot Data Strings Per ID https://community.qlik.com/t5/App-Development/Pivot-Data-Strings-Per-ID/m-p/1868121#M71687 <P>Hi, I have been stuck on this query for a while looking to see if anyone has any ideas on how to do this?</P> <P>I have a long data set that looks similar to this&nbsp;</P> <TABLE width="254"> <TBODY> <TR> <TD width="126">interation_ID</TD> <TD width="64">Name</TD> <TD width="64">leg_ID</TD> </TR> <TR> <TD>1000001</TD> <TD>John</TD> <TD>1</TD> </TR> <TR> <TD>1000001</TD> <TD>Jack</TD> <TD>2</TD> </TR> <TR> <TD>1000001</TD> <TD>Jeff</TD> <TD>3</TD> </TR> <TR> <TD>1000001</TD> <TD>July</TD> <TD>4</TD> </TR> <TR> <TD>1000002</TD> <TD>Jack</TD> <TD>1</TD> </TR> <TR> <TD>1000002</TD> <TD>Alex</TD> <TD>2</TD> </TR> <TR> <TD>1000003</TD> <TD>Rachel</TD> <TD>3</TD> </TR> <TR> <TD>1000003</TD> <TD>Chris</TD> <TD>4</TD> </TR> <TR> <TD>1000003</TD> <TD>Simon</TD> <TD>5</TD> </TR> <TR> <TD>1000003</TD> <TD>Toby</TD> <TD>6</TD> </TR> <TR> <TD>1000003</TD> <TD>Joy</TD> <TD>7</TD> </TR> <TR> <TD>1000003</TD> <TD>Ryan</TD> <TD>8</TD> </TR> <TR> <TD>1000003</TD> <TD>James</TD> <TD>9</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>As i now need to build a sankey chart i am trying to get the dataset to be wide as opposed to long. IE&nbsp;</P> <TABLE width="574"> <TBODY> <TR> <TD width="126">1000001</TD> <TD width="64">John</TD> <TD width="64">Jack</TD> <TD width="64">Jeff</TD> <TD width="64">July</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> </TR> <TR> <TD>1000002</TD> <TD>Jack</TD> <TD>Alex</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>1000003</TD> <TD>Rachel</TD> <TD>Chris</TD> <TD>Simon</TD> <TD>Toby</TD> <TD>Joy</TD> <TD>Ryan</TD> <TD>James</TD> </TR> </TBODY> </TABLE> Sat, 16 Nov 2024 16:53:13 GMT https://community.qlik.com/t5/App-Development/Pivot-Data-Strings-Per-ID/m-p/1868121#M71687 Rogers2212 2024-11-16T16:53:13Z Re: Pivot Data Strings Per ID https://community.qlik.com/t5/App-Development/Pivot-Data-Strings-Per-ID/m-p/1868139#M71689 <P>Have a look at solutions using Generic Load and then table concatenation:</P> <P><A href="https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/" target="_blank">https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/</A></P> <P>Or loop-based solutions that don't use Generic Load:</P> <P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/how-to-combine-after-generic-load/td-p/1380839" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Sense/how-to-combine-after-generic-load/td-p/1380839</A></P> <P>&nbsp;</P> Wed, 08 Dec 2021 14:44:17 GMT https://community.qlik.com/t5/App-Development/Pivot-Data-Strings-Per-ID/m-p/1868139#M71689 Or 2021-12-08T14:44:17Z