Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
uko223
Contributor III
Contributor III

create single delimited dimension based on values of another dimension

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!

 

 

2 Solutions

Accepted Solutions
3 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

sugathirajkumar
Creator
Creator

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
];