Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srcapille
Contributor
Contributor

Grouping values

I have two columns of data in Excel:

1. FAMILY CODE

2. NAME

How do i group the lines from NAME Column  by FAMILY CODE

Here is a example:

FAMILY CODE                   NAME
46739723                          ANTONIO CARLOS
46739723                         JOANA MARIA
49643062                          FERNANDA LIMA
49643062                          TENORIO DE CAMPOS
49643735                          ARMANDO FERNANDES
49643735                          ANDERSON ANTUNES

1 Reply
Vegar
MVP
MVP

Try something like this

Load
[FAMILY CODE],
Concat(NAME, ',') AS NAMES
FROM ExcelFile
Group by [FAMILY CODE]
;