https://community.qlik.com/t5/QlikView/Agrupar-Valores-Repetidos/m-p/1563093#M741651 <P>Boa noite.</P><P>Estou montando uma consulta de dados e estou apanhando com uma situação simples.</P><P>Tenho duas colunas, uma com CODIGO FAMILIAR e outra com NOME.&nbsp;</P><P>Preciso agrupar todos os nomes de um mesmo CODIGO FAMILIAR e não estou acertando.</P><P><STRONG>CODIGO DA FAMILIA&nbsp; &nbsp; &nbsp;NOME</STRONG><BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANTONIO CARLOS<BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JOANA MARIA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FERNANDA LIMA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TENORIO DE CAMPOS<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ARMANDO FERNANDES<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANDERSON ANTUNES</P> Wed, 25 Nov 2020 16:16:04 GMT srcapille 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Agrupar-Valores-Repetidos/m-p/1563093#M741651 <P>Boa noite.</P><P>Estou montando uma consulta de dados e estou apanhando com uma situação simples.</P><P>Tenho duas colunas, uma com CODIGO FAMILIAR e outra com NOME.&nbsp;</P><P>Preciso agrupar todos os nomes de um mesmo CODIGO FAMILIAR e não estou acertando.</P><P><STRONG>CODIGO DA FAMILIA&nbsp; &nbsp; &nbsp;NOME</STRONG><BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANTONIO CARLOS<BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JOANA MARIA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FERNANDA LIMA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TENORIO DE CAMPOS<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ARMANDO FERNANDES<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANDERSON ANTUNES</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Agrupar-Valores-Repetidos/m-p/1563093#M741651 srcapille 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Agrupar-Valores-Repetidos/m-p/1572998#M741652 Quando você menciona "agrupar", se refere a inserir um nome ao lado do outro? Se sim:<BR /><BR />// Exemplo sendo que o caractere entre um nome e outro seja a vírgula:<BR /><BR />DATA:<BR />LOAD<BR />[CODIGO FAMILIA],<BR />Concat(NOME, ', ') as NOMEAGRUPADO<BR />From .....<BR />Group By [CODIGO FAMILIA];<BR /> Thu, 25 Apr 2019 01:43:24 GMT https://community.qlik.com/t5/QlikView/Agrupar-Valores-Repetidos/m-p/1572998#M741652 lfetensini 2019-04-25T01:43:24Z