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