Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Try looking at Concat function:
Regards,
JP
Hi,
Try looking at Concat function:
Regards,
JP
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
];