topic Re: Script linha para coluna in Brasil https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517557#M14656 <HTML><HEAD></HEAD><BODY><P>Olá, você pode fazer o Join</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro _jivemacro_uid_13843487547856270 jive_macro_code" jivemacro_uid="_13843487547856270"> <P>LOAD</P> <P>&nbsp;&nbsp;&nbsp; COD,</P> <P>&nbsp;&nbsp;&nbsp; VALOR AS VALOR1</P> <P>FROM TAB</P> <P>WHERE TIPO=1;</P> <P></P> <P>JOIN</P> <P>LOAD</P> <P>&nbsp;&nbsp;&nbsp; COD,</P> <P>&nbsp;&nbsp;&nbsp; VALOR AS VALOR2</P> <P>FROM TAB</P> <P>WHERE TIPO=2;</P> </PRE><P></P><P>Abraços.</P><P>Tonial.</P></BODY></HTML> Wed, 13 Nov 2013 13:19:32 GMT fernando_tonial 2013-11-13T13:19:32Z Script linha para coluna https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517556#M14655 <HTML><HEAD></HEAD><BODY><P>Olá Caros, bom dia!</P><P></P><P>Como transformar uma linha para coluna no script?</P><P></P><P>Tabela original:</P><P></P><P>COD&nbsp;&nbsp; TIPO&nbsp;&nbsp; VALOR</P><P>001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1000</P><P>001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 2000</P><P></P><P>Tabela que necessito:</P><P></P><P>COD&nbsp;&nbsp;&nbsp; VALOR1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALOR2</P><P>001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P></P><P>Agradeco se alguem puder ajudar!!</P></BODY></HTML> Wed, 13 Nov 2013 13:14:40 GMT https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517556#M14655 2013-11-13T13:14:40Z Re: Script linha para coluna https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517557#M14656 <HTML><HEAD></HEAD><BODY><P>Olá, você pode fazer o Join</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro _jivemacro_uid_13843487547856270 jive_macro_code" jivemacro_uid="_13843487547856270"> <P>LOAD</P> <P>&nbsp;&nbsp;&nbsp; COD,</P> <P>&nbsp;&nbsp;&nbsp; VALOR AS VALOR1</P> <P>FROM TAB</P> <P>WHERE TIPO=1;</P> <P></P> <P>JOIN</P> <P>LOAD</P> <P>&nbsp;&nbsp;&nbsp; COD,</P> <P>&nbsp;&nbsp;&nbsp; VALOR AS VALOR2</P> <P>FROM TAB</P> <P>WHERE TIPO=2;</P> </PRE><P></P><P>Abraços.</P><P>Tonial.</P></BODY></HTML> Wed, 13 Nov 2013 13:19:32 GMT https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517557#M14656 fernando_tonial 2013-11-13T13:19:32Z Re: Script linha para coluna https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517558#M14657 <HTML><HEAD></HEAD><BODY><P>Obrigado Tonial, deu certo.</P><P></P><P>Abraço!</P></BODY></HTML> Wed, 13 Nov 2013 15:18:33 GMT https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517558#M14657 2013-11-13T15:18:33Z Re: Script linha para coluna https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517559#M14658 <HTML><HEAD></HEAD><BODY><P>Ótimo,</P><P>Favor marcar como respondida, assim ajuda os demais da comunidade.</P><P></P><P>Abraços.</P><P>Tonial.</P></BODY></HTML> Wed, 13 Nov 2013 19:21:15 GMT https://community.qlik.com/t5/Brasil/Script-linha-para-coluna/m-p/517559#M14658 fernando_tonial 2013-11-13T19:21:15Z