How to Convert XML to Csv using Data Flow ADF | Flatten or Normalize Xml Source

[@shubhamgomase9056]

Thanks, Great help.!

[@mohitupadhayay1439]

How can I detect the corrupt records while reading the XML file and store in a separate csv.
also is there a way to find a reason for the same?

[@brchudson]

Very helpful. Thank you

[@mohitupadhayay1439]

Remember : The Dataflows only work on Auto resolve Integration Runtime.
Self Integration Runtime is not supported.

[@NikhilBhavsar-o2m]

How to insert only file names from blob storage to sql database and after running it for second time only new file name must be added in the sql table

[@fredericMercier-f7p]

Thank you!