Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

stascher
Contributor

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?

Tags (3)
1 Reply
stascher
Contributor

Re: Simplify a table

Nevermind,. I forgot the Group BY clause.

Community Browser