topic Re: Separar grupos de produtos, agrupados em uma única coluna da tabela in Brasil https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739385#M22284 <HTML><HEAD></HEAD><BODY><P>Obrigado mais uma vez meu amigo, show, foi na hora.</P><P></P><P>Abraços,</P><P></P><P>Marcos André.</P></BODY></HTML> Thu, 27 Nov 2014 18:24:54 GMT Anonymous 2014-11-27T18:24:54Z Separar grupos de produtos, agrupados em uma única coluna da tabela https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739382#M22281 <HTML><HEAD></HEAD><BODY><P>Boa tarde a todos.</P><P></P><P>Estou com uma situação aqui, que não consegui sanar, e gostaria da ajuda dos senhores, como sempre, rs.</P><P></P><P>Estou anexando a tabela para caso queiram dar uma olhada...</P><P></P><P>Apenas para exemplificar:</P><P>Como está:</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/72311_pastedImage_2.png" style="width: 620px; height: 207px;" /></P><P></P><P>Como preciso que esteja:</P><P>ID_CONTROLE_ORCAMENTO | ID_ALMOXARIFADO | ID_GRUPO | ........ | DS CONTROLE</P><P>205&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NIT</P><P>205&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NIT</P><P>205&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NIT</P><P>...</P><P>61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LAR</P><P>61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LAR</P><P>61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LAR</P><P></P><P>e assim, sucessivamente.....</P><P></P><P>Vejam, que estou separando os grupos (que estão sepadados por virgula na coluna ID_GRUPO, linha a linha...</P><P></P><P>Espero que de para entender....</P><P>Obrigado antecipadamente.</P><P>Marcos,</P></BODY></HTML> Thu, 27 Nov 2014 16:31:31 GMT https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739382#M22281 Anonymous 2014-11-27T16:31:31Z Re: Separar grupos de produtos, agrupados em uma única coluna da tabela https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739383#M22282 <HTML><HEAD></HEAD><BODY><P>Marcos, você vai ter que fazer alguns IFs e depois utilizar o recurso CrossTable. Os Ifs são para separar cada ID em uma coluna e depois o CrossTable é para transformar essas colunas novas que você criou em linhas. Basicamente esse é o caminho das pedras.</P><P></P><P>Caso necessite, posso te montar um exemplo! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 27 Nov 2014 16:49:51 GMT https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739383#M22282 nicolett_yuri 2014-11-27T16:49:51Z Re: Separar grupos de produtos, agrupados em uma única coluna da tabela https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739384#M22283 <HTML><HEAD></HEAD><BODY><P>Olá Marcos,</P><P></P><P>Você pode utilizar a função Subfield(), mas lembrando que o campo de valor ficará conforme a quantidade de ID_GRUPO que tem em cada uma das linhas.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14171073422654591" jivemacro_uid="_14171073422654591"> <P>Dados:</P> <P>LOAD ID_CONTROLE_ORCAMENTO, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; ID_ALMOXARIFADO, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; SubField(ID_GRUPO,',') AS ID_GRUPO, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; VL_ORCAMENTO, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; DT_INICIO_VIGENCIA, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; DT_FIM_VIGENCIA, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; DS_CONTROLE</P> <P>FROM</P> <P>CONTROLE_ORCAMENTOS.QVD</P> <P>(qvd);</P> </PRE><P></P><P>Qlikfique-se.</P><P>Tonial</P></BODY></HTML> Thu, 27 Nov 2014 16:55:54 GMT https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739384#M22283 fernando_tonial 2014-11-27T16:55:54Z Re: Separar grupos de produtos, agrupados em uma única coluna da tabela https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739385#M22284 <HTML><HEAD></HEAD><BODY><P>Obrigado mais uma vez meu amigo, show, foi na hora.</P><P></P><P>Abraços,</P><P></P><P>Marcos André.</P></BODY></HTML> Thu, 27 Nov 2014 18:24:54 GMT https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739385#M22284 Anonymous 2014-11-27T18:24:54Z Re: Separar grupos de produtos, agrupados em uma única coluna da tabela https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739386#M22285 <HTML><HEAD></HEAD><BODY><P>Ótimo, quando tenho algum tempo posso ajudar.</P><P></P><P>Qlikfique-se.</P><P>Tonial.</P></BODY></HTML> Thu, 27 Nov 2014 18:27:11 GMT https://community.qlik.com/t5/Brasil/Separar-grupos-de-produtos-agrupados-em-uma-%C3%BAnica-coluna-da/m-p/739386#M22285 fernando_tonial 2014-11-27T18:27:11Z