Apr 07 2023 04:40 PM
We have CSV file in this format.
UID | Catalog_Names |
152376 | <catalogs> <Catalog Name="NEWYORK" RequireApprove="True"/> </catalogs> |
413683 | <catalogs> <Catalog Name="BOSTON" RequireApprove="True"/> </catalogs> |
347687 | <catalogs> <Catalog Name="DALLAS" RequireApprove="True"/> </catalogs> |
Need to parse/flatten the columns
I need file with column names: UID, Catalog Name, RequireApprove w.r.t data using Dataflow in Azure DataFactory.
I tried using Parse activity in Dataflow with the expression
Thank you.
Apr 08 2023 12:21 AM
Apr 10 2023 06:21 AM
<catalogs>
<Catalog Name="NEWYORK"
RequireApprove="True"/>
</catalogs>
Exp: