Azure data flow - access Nested XML data convert to CSV and stored it in ADLS

HemanthKumar loka 226

This is xml data. I need to access the all columns in the file . And convert to CSV.

\
\
\
\

Can you please help me.

Accepted answer

MarkKromer-MSFT 5,186 Reputation points Microsoft Employee

2022-04-28T03:28:12.677+00:00

Use a Select transformation to turn properties from each of the hierarchies into columns (see example below) using rule-based mapping.
Please sign in to rate this answer.
AnnuKumari-MSFT 31,151 Reputation points Microsoft Employee

2022-04-29T16:15:17.007+00:00

Hi @HemanthKumar loka ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

AnnuKumari-MSFT 31,151 Reputation points Microsoft Employee

2022-05-02T05:25:33.81+00:00

Hi @HemanthKumar loka ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

Chaudhary, Ravi (C) 0 Reputation points

2023-05-09T03:41:45.56+00:00

@AnnuKumari-MSFT : Could you please answer the following question https://learn.microsoft.com/en-us/answers/questions/1280228/parse-xml-values-saved-in-sql-table-column-in-adf
Sign in to comment

0 additional answers