question

PrabodhPurwarMINDTREELIMITED-2505 avatar image
0 Votes"
PrabodhPurwarMINDTREELIMITED-2505 asked PrabodhPurwarMINDTREELIMITED-2505 commented

how to convert a column wise data into the Row wise data in Azure data factory?

I have one Column which is having Multiple value like

Account No ---> Values

12345------{PC Accessories, Surface, Xbox, Cross Category, Windows, Microsoft 365}


I want to change the Value in the Row Wise

Account No Value

12345----PC Accessories,

12345 Surface,

12345 Xbox

12345 Cross Category

12345 Windows,

12345 Microsoft 365

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered PrabodhPurwarMINDTREELIMITED-2505 commented

Hey, you can use unpivot function in adf data flow.
https://docs.microsoft.com/en-us/azure/data-factory/data-flow-unpivot

In case if your datasource is a SQL source itself, would suggest leveraging unpivot sql function

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.