Forum Discussion
Solved
Conditional Column on dynamical Combination delimiters values
Hi All, Need some help. I am trying to achieve the below requirement. By using if else condition I can achieve the below result set. However, the combinations of the "Fruit Long Name" changes. dynam...
Try this custom column
=let mylist=Text.Split([Fruit Long Name],",") in Text.Combine( List.Transform(mylist, (x)=> Text.At(Text.Trim(x),0)) , ",")
Try this custom column
=let mylist=Text.Split([Fruit Long Name],",")
in
Text.Combine(
List.Transform(mylist, (x)=> Text.At(Text.Trim(x),0))
,
",")
@Zubair_Muhammad It worked as expected. Thank you.