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

Find more posts tagged with

AI Studio

Accepted answers

lionelderkrikor

Hi @sgnarkhede2016,

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

Regards,

Lionel

generate_aggregation.rmp

All comments

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

lionelderkrikor

Hi @sgnarkhede2016,

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

Regards,

Lionel

generate_aggregation.rmp

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)