Forum Discussion

StephaneBouillon's avatar
StephaneBouillon
Brass Contributor
Sep 19, 2023

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

Resources