Qlik Community

Qlik Sense Cloud Discussions

Not applicable

remove duplicate

Hi,

I'm looking for remove duplicate lines and aggregate data. Could you help me please ?

initial data :

CUSTOMERNICKNAMEAGESTATUS
1234567MOMO21
1234567MOMOF

aggregate data :

CUSTOMERNICKNAMEAGESTATUS
1234567MOMO21F

Best,

Frédéric

1 Reply

Re: remove duplicate

May be like this:

LOAD CUSTOMER,

          NICKNAME,

          Concat(AGE) as AGE,

          Concat(STATUS) as STATUS

FROM ...

Group By CUSTOMER, NICKNAME;

Community Browser