Forum Discussion
StephaneBouillon
Sep 19, 2023Brass Contributor
Create a derived column containing filtered repeating xml element
Hi, I want to do something simple in a data flow. I have a structure such as
<Product>
<ProductId>12345</ProductId>
<Description>
<Lng>EN</Lng>
<Dsc>English Description</Dsc>
</Description>
<Description>
<Lng>FR</Lng>
<Dsc>French Description</Dsc>
</Description>
<Description>
<Lng>DE</Lng>
<Dsc>German Description</Dsc>
</Description>
</Product>
What I need is a record with columns ProductId and Desc where Desc is the English description
I tried different options with Flatten and Derived Column transformations with an expression where Lng=="EN" but haven't found the right syntax.
Can anybody help here ?
Stephane
No RepliesBe the first to reply