Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears , I have below table , customer can have multiple services , what I need is to create new column with what customer has please check below tables to understand :
current data :
Customer Number | Type |
1 | Mobile |
1 | Data |
2 | Mobile |
3 | Mobile |
4 | Data |
5 | Mobile |
5 | Data |
expected result :
Customer Number | Product Summary |
1 | Mobile & Data |
2 | Mobile |
3 | Mobile |
4 | Data |
5 | Mobile & data |
If in chart:
Dimension: [Customer Number]
Measure: Concat(type, ' & ')
If in script:
LOAD
[Customer Number]
Concat(type, ' & ') as [Product Summary]
Resident yourtable
Group By [Customer Number];
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
If in chart:
Dimension: [Customer Number]
Measure: Concat(type, ' & ')
If in script:
LOAD
[Customer Number]
Concat(type, ' & ') as [Product Summary]
Resident yourtable
Group By [Customer Number];
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Thank you very much , I'm using script , and this is a prefect solution ,just one question please the result give some times for some records duplicated data which is also correct as data but just to give a good look how to remove the duplicate example :
Customer Number | Product Summary |
1 | Mobile & Data & Mobile & Data & Data |
Concat(DISTINCT type, ' & ') as [Product Summary]
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com