topic Re: Como transformar multiplos dados de linhas em multiplas colunas para um id igual in Brasil https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341634#M48850 <HTML><HEAD></HEAD><BODY><P>Thank you Michele!</P></BODY></HTML> Sun, 28 May 2017 18:45:52 GMT Anonymous 2017-05-28T18:45:52Z Como transformar multiplos dados de linhas em multiplas colunas para um id igual https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341630#M48846 <HTML><HEAD></HEAD><BODY><P>Olá pessoal!</P><P></P><P>Segue a minha dúvida:</P><P></P><P>Eu tenho os seguintes dados:</P><P></P><P>id&nbsp;&nbsp;&nbsp;&nbsp; data</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 01/02/2016</P><P><SPAN style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp; 03/02/2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp; 05/02/2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp; 11/02/2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp; 21/02/2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp; 22/02/2016</SPAN></P><P></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">e quero converter no seguinte formato:</SPAN></P><P style="font-size: 13.3333px;">id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data3</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/02/2016<SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/02/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">05/02/2016</SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/02/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">21/02/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">22/02/2016</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Agradeço se puderem me ajudar<BR /></SPAN></P></BODY></HTML> Fri, 26 May 2017 01:48:14 GMT https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341630#M48846 Anonymous 2017-05-26T01:48:14Z Re: Como transformar multiplos dados de linhas em multiplas colunas para um id igual https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341631#M48847 <HTML><HEAD></HEAD><BODY><P>You need a third column, then use it in SetAnalysis achieve your goal.<IMG alt="Immagine.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164811_Immagine.png" style="height: 202px; width: 620px;" /></P></BODY></HTML> Fri, 26 May 2017 06:20:03 GMT https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341631#M48847 micheledenardi 2017-05-26T06:20:03Z Re: Como transformar multiplos dados de linhas em multiplas colunas para um id igual https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341632#M48848 <HTML><HEAD></HEAD><BODY><P>Amigo, segue. </P><P></P><P><A href="https://community.qlik.com/message/78337">Row values as fields (opposite of crosstable?)</A></P></BODY></HTML> Fri, 26 May 2017 10:41:20 GMT https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341632#M48848 mario_sergio_ti 2017-05-26T10:41:20Z Re: Como transformar multiplos dados de linhas em multiplas colunas para um id igual https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341633#M48849 <HTML><HEAD></HEAD><BODY><P>Hi Mauricio,</P><P>try this</P><P><SPAN style="color: #0000ff; font-size: 10pt;">Generic</SPAN><SPAN style="font-size: 10pt;"><BR /> <STRONG style=": ; color: #0000ff;">LOAD</STRONG> <SPAN style="color: #800000;">id</SPAN>,'data'&amp;<SPAN style="color: #0000ff;">AutoNumber</SPAN>(<SPAN style="color: #0000ff;">RowNo</SPAN>(),<SPAN style="color: #800000;">id</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">D1</SPAN>,<SPAN style="color: #800000;">data</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> id, data<BR /> 1, 01/02/2016<BR /> 1, 03/02/2016<BR /> 1, 05/02/2016<BR /> 2, 11/02/2016<BR /> 2, 21/02/2016<BR /> 2, 22/02/2016<BR /> ]</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164862_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Fri, 26 May 2017 10:59:19 GMT https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341633#M48849 antoniotiman 2017-05-26T10:59:19Z Re: Como transformar multiplos dados de linhas em multiplas colunas para um id igual https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341634#M48850 <HTML><HEAD></HEAD><BODY><P>Thank you Michele!</P></BODY></HTML> Sun, 28 May 2017 18:45:52 GMT https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341634#M48850 Anonymous 2017-05-28T18:45:52Z Re: Como transformar multiplos dados de linhas em multiplas colunas para um id igual https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341635#M48851 <HTML><HEAD></HEAD><BODY><P>Thank you Antonio!</P></BODY></HTML> Sun, 28 May 2017 18:46:18 GMT https://community.qlik.com/t5/Brasil/Como-transformar-multiplos-dados-de-linhas-em-multiplas-colunas/m-p/1341635#M48851 Anonymous 2017-05-28T18:46:18Z