create single delimited dimension based on values of another dimension

[uko223]

I would like to create new dimension that has single delimited values based on corresponding dimesinos. For example, it we have the dimensions "Account" and "Name"

Account - Name

123             Advanced

123             Premier

123            Nova

The new dimension would display name as below:

Account - Name

123            Advanced; Premier; Nova. 

And would do this automatically id there is more that one Name per Account. 

Thanks!

[jpenuliar · Accepted solution]

Hi,

Try looking at Concat function:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Strin...

Regards,

JP

[sugathirajkumar]

A:

load Id,
Concat(Name,';') as name
Group by Id;
Load * Inline [
Id,Name
1,Lakshmipathi
1,Baag
1,Hema
2,Geetha
2,Siri
3,Latha
];

[sugathirajkumar · Accepted solution]