topic Re: Como separar String em linhas / colunas in Brasil https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080337#M37461 <HTML><HEAD></HEAD><BODY><P>Você poderia utilizar o comando subfield.</P><P></P><P>Subfield:</P><P>load</P><P>SubField(Produtos,',') as Produto,</P><P>*;</P><P>load * Inline [</P><P>Título&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Produtos,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cliente</P><P>T1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'P1,P2,P3' ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01</P><P>];</P></BODY></HTML> Mon, 28 Mar 2016 15:46:37 GMT tiago_hubner 2016-03-28T15:46:37Z Como separar String em linhas / colunas https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080336#M37460 <HTML><HEAD></HEAD><BODY><P>Tenho uma tabela com as colunas TITULO, PRODUTOS e CLIENTE.</P><P>Porém, na coluna PRODUTOS, os códigos dos produtos serão separados por vírgulas:</P><P></P><P>Ex.</P><P>Título&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Produtos&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cliente</P><P>T1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1, P2,P3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01</P><P></P><P></P><P>Como faria para separar esses produtos por tupla repetindo as demais informações da tupla?</P><P>Ex.</P><P>Título.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Produtos&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cliente&nbsp;&nbsp;&nbsp;&nbsp; </P><P>T1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01</P><P>T1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01</P><P>T1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01</P></BODY></HTML> Mon, 28 Mar 2016 15:27:51 GMT https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080336#M37460 2016-03-28T15:27:51Z Re: Como separar String em linhas / colunas https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080337#M37461 <HTML><HEAD></HEAD><BODY><P>Você poderia utilizar o comando subfield.</P><P></P><P>Subfield:</P><P>load</P><P>SubField(Produtos,',') as Produto,</P><P>*;</P><P>load * Inline [</P><P>Título&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Produtos,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cliente</P><P>T1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'P1,P2,P3' ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01</P><P>];</P></BODY></HTML> Mon, 28 Mar 2016 15:46:37 GMT https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080337#M37461 tiago_hubner 2016-03-28T15:46:37Z Re: Como separar String em linhas / colunas https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080338#M37462 <HTML><HEAD></HEAD><BODY><P>Obrigado, problema solucionado mais rápido do que ligeiro. </P></BODY></HTML> Mon, 28 Mar 2016 17:54:15 GMT https://community.qlik.com/t5/Brasil/Como-separar-String-em-linhas-colunas/m-p/1080338#M37462 2016-03-28T17:54:15Z