How to Store values in Column with Pipe separated

sgnarkhede2016

Hello ,

For example, If have  a three column

Customer Id  Risk Profile  Direction
1233               HIGH             I

I want to generate fourth column "Parameter Value"

"Parameter Value"
1233|HIGH|I

please do needfule

lionelderkrikor

Hi @sgnarkhede2016,

In attached file, the process which performs what you want to do based on Martin's idea .

Regards,

Lionel

MartinLiebig

Hi,

Generate Aggregation with aggregation "concat" is what you search for.

~Martin

sgnarkhede2016

Generate Aggregation with aggregation "concat" it only work for two attribute but have upto eight attribute