Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Any one help me to do long table to short table in Qlikview . Please check the below image of scenario.
Thanks in advance.
May be this
LOAD CUSTOMER_NUMBER,
Concat(DISTINCT ORDER_ID, ',') as ORDER_ID
FROM ...
Group By CUSTOMER_NUMBER;
May be this
LOAD CUSTOMER_NUMBER,
Concat(DISTINCT ORDER_ID, ',') as ORDER_ID
FROM ...
Group By CUSTOMER_NUMBER;
Or if you want to do this in the straight table
dimension: customer_Id
expression : concat(ORDER_ID,',')
stalwar1 . Thank you.
@Sasidhar Parupudi Thank you for your reply.