Multiple row change to single row from imported file?

[PawanGu]

Data Loading file like below:

First_Name	Last_name	Id	Industry
Jack	Row	11	Apple
Neil	Sanyal	22	Reliance
Viveck	Gupta	33	Adidas
Sukant	Ashk	44	Puma
Gagan	Sharma	55	Reebok

Out put look like:

First_Name	Last_name	Id	Industry
Jack;Neil;Viveck;Sukant;Gagan	Row; Sanyal;Gupta;Ashk;Sharma	11;22;33;44;55	Apple; Reliance; Adidas; Puma; Reebok

[PawanGu]

Anyone Help me?

[abount]

Hi @PawanGu,

You can utilise the Enrichment activity to transpose your column data.

After you load your data via a 'Load file' activity, add an Enrichment activity.

Add an element at the ADDITIONAL DATA with a value 1.

Then add a second Enrichment activity to create a self-join to your table with N cardinality, using the Unit_One attribute you created at the first Enrichment.

At the ADVANCED RELATIONS tab, Add an element. From the Cardinality drop-down menu choose N cardinality collection link. Create element for your Reconciliation criteria by choosing unitOne for the Source and the Destination.

Then at the ADDITIONAL DATA tab Create element and as an Expression  Select the Enrichment 2 you created at ADVANCED RELATIONS. 

When you add the new Expression make sure at the Parameters to choose Aggregates at the Select how the data is collected.

At the Data tab you will create the expressions you require. Let's create our first expression by choosing at Aggregate - String Aggregate (with separator character)  and from Expression select First_Name. Give it a useful Label like StringAgg(First_Name) or whatever you prefer.

Repeat the step by adding three more elements with a String Aggregate for Surname, ID and Industry

You have now created the transposed fields you require.

If you have completed the steps above, you should see the data in the transition below

Hope this was helpful.

If you require the same solution but for the Adobe Classic check this one

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-pivot-up-th...

Thanks