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

Question

Loka HemanthKumar 226

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

\
\
\
\

Can you please help me.

Answer accepted by question author

0 additional answers

Answer 1

MarkKromer-MSFT 5,231 Microsoft Employee Moderator

Use a Select transformation to turn properties from each of the hierarchies into columns (see example below) using rule-based mapping.

AnnuKumari-MSFT 34,561 Reputation points Microsoft Employee Moderator

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

Hi @Loka HemanthKumar ,
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 34,561 Reputation points Microsoft Employee Moderator

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

Hi @Loka HemanthKumar ,
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.
Anonymous

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