How to pivot up the data?

[Data_guy]

I have below scenario:-

CUST_ID  JOB_CD

123            ABC

123            XYX

OUTPUT:-

123       ABC, XYZ

[kapilKochar · Accepted solution]

Hi,

You can use Query activity and Enrichment in a workflow to change your data set and get result in above format. Try below steps

A) As an example I have created a schema name as cus:pivot

B) Create a workflow like below 

i) Query activity

ii) Take the enrichment activity and make the self join with same table with the help of 1: N join while giving join condition

While adding the data please make sure to add column(No. of records to retrieve as per your convenience (By default it will be max 3 rows) ). So it will create multiple enrichment table based on your records to retrieve. In below example since I have two values so I have selected two

Add your data from these different temp enrichment table and result will be like below

Hope this helps. 

[Data_guy]

Thanks Kapil.

I am not able to find "Select additional columns" from your snippet. Where to set these columns to create field?

[kapilKochar]

Here you go