topic Re: Pivotar Tabela in Brasil https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230512#M43576 <HTML><HEAD></HEAD><BODY><P>Amigo, exite uma função que vai te ajudar;</P><P></P><P>Adapte no script:</P><P></P><P>Generic LOAD * FROM abc.csv;</P><P></P><P>Referência: <A href="https://help.qlik.com/pt-BR/sense/3.1/Subsystems/Hub/Content/DataSource/generic-databases.htm" title="https://help.qlik.com/pt-BR/sense/3.1/Subsystems/Hub/Content/DataSource/generic-databases.htm">https://help.qlik.com/pt-BR/sense/3.1/Subsystems/Hub/Content/DataSource/generic-databases.htm</A></P></BODY></HTML> Wed, 11 Jan 2017 15:21:26 GMT mario_sergio_ti 2017-01-11T15:21:26Z Pivotar Tabela https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230511#M43575 <HTML><HEAD></HEAD><BODY><P>Caros, Boa tarde!</P><P></P><P>Tenho um arquivo XLS que é uma extração de um formulado com varias perguntas</P><P></P><P>Preciso fazer com que cada resposta dada se torne uma coluna, por exemplo</P><P></P><P>XLS Original</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">id</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Resposta</TH></TR><TR><TD style="padding: 2px;">001</TD><TD style="padding: 2px;">Achou caro</TD></TR><TR><TD style="padding: 2px;">001</TD><TD style="padding: 2px;">concorrencia</TD></TR><TR><TD style="padding: 2px;">002</TD><TD style="padding: 2px;"><P>possui fidelidade</P></TD></TR><TR><TD>002</TD><TD>valor alto</TD></TR></TBODY></TABLE><P></P><P></P><P>como deve ficar depois da carga</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">001</TD><TD style="padding: 2px;">Achou Caro</TD><TD style="padding: 2px;">concorrencia</TD></TR><TR><TD style="padding: 2px;">002</TD><TD style="padding: 2px;">possui fidelidade</TD><TD style="padding: 2px;">valor alto</TD></TR></TBODY></TABLE><P></P><P>É possível fazer esta transformação?</P></BODY></HTML> Wed, 11 Jan 2017 15:06:20 GMT https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230511#M43575 mercadante 2017-01-11T15:06:20Z Re: Pivotar Tabela https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230512#M43576 <HTML><HEAD></HEAD><BODY><P>Amigo, exite uma função que vai te ajudar;</P><P></P><P>Adapte no script:</P><P></P><P>Generic LOAD * FROM abc.csv;</P><P></P><P>Referência: <A href="https://help.qlik.com/pt-BR/sense/3.1/Subsystems/Hub/Content/DataSource/generic-databases.htm" title="https://help.qlik.com/pt-BR/sense/3.1/Subsystems/Hub/Content/DataSource/generic-databases.htm">https://help.qlik.com/pt-BR/sense/3.1/Subsystems/Hub/Content/DataSource/generic-databases.htm</A></P></BODY></HTML> Wed, 11 Jan 2017 15:21:26 GMT https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230512#M43576 mario_sergio_ti 2017-01-11T15:21:26Z Re: Pivotar Tabela https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230513#M43577 <HTML><HEAD></HEAD><BODY><P>Você precisa disso: <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P></BODY></HTML> Wed, 11 Jan 2017 16:12:14 GMT https://community.qlik.com/t5/Brasil/Pivotar-Tabela/m-p/1230513#M43577 Clever_Anjos 2017-01-11T16:12:14Z