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: 
stascher
Partner - Creator II
Partner - Creator II

Simplify a table

Hi.  I should lose points for asking this, it's such a simple question, but I keep getting a load error.

I have a table Table1 like:

column_1column_2

A

AA
ABB
ACC
BDD
BEE
BFF

I want to create the following Table2:

column_acolumn_b
AAA,BB,CC
BDD,EE,FF

Table2:

load distinct column_1 as column_a,

concat(column_2,',') as column_b

resident Table1;

The above doesn't work. What should I be using?

1 Reply
stascher
Partner - Creator II
Partner - Creator II
Author

Nevermind,. I forgot the Group BY clause.