How to convert long table to short table

[debabrata_sahoo]

Hello,

Any one help me to do long table to short table in Qlikview . Please check the below image of scenario.

Thanks in advance.

[sunny_talwar · Accepted solution]

May be this

LOAD CUSTOMER_NUMBER,

      Concat(DISTINCT ORDER_ID, ',') as ORDER_ID

FROM ...

Group By CUSTOMER_NUMBER;

[sasiparupudi1]

Or if you want to do this in the straight table

dimension: customer_Id

expression : concat(ORDER_ID,',')

[debabrata_sahoo]

stalwar1‌ . Thank you.

[debabrata_sahoo]

@Sasidhar Parupudi  Thank you for your reply.