How to take the first row of multiple Fields based on a condition dynamically

[MostafaBouzari]

Hi All,

i want to take the first row of the data dynamically but based on a condition.

E.g

if contains(All the Fields here(or CurrentFields),'Source or FileName') then don't  Rename it Else take the first row of the data as Name EndIf

this is how my column looks like and don't want to rename the Filename or Source Column

How can i achieve this?

Best Regards

 

[danilang · Accepted solution]

Hi @MostafaBouzari 

This was a fun one.  

giving

The annotations describe what happens at each step, but let me know if you need more explanation

Dan

[MostafaBouzari]

Beautifully done