Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am using two custom columns for one query which I feel can be done in one query. So I have the data and I grouped all the data based on ID. The new column was grouped and names as column1. I wanted to concatenate the data for each column if ID was same. I was using below code for the custom column :
Table.Column([column1],"Vendor Description")
Then I extracted the value basaed on comma delimeter
but the problem was if two rows had same id and the concatenation was done based on above column so if there was same values they were showing like below:
I wanted it to show only single value if both values were same and if both values were different values then show the different values so for that I created another custom column below:
Text.Combine( List.Distinct( List.Transform([column1][Vendor Description], Text.Trim)),",")
It was working completely fine. Its resuls look like below:
I want to both the codes below to be merge into single in some way I can get concatenation as well removal of duplicate after the comma.
Table.Column([column1],"Vendor Description")
Text.Combine( List.Distinct( List.Transform([column1][Vendor Description], Text.Trim)),",")
Help would be appreciated.
Thank you
Solved! Go to Solution.
@Junaid11 Oh, right, Table.Column returns a list. How about:
Text.Combine( List.Distinct( List.Transform(Table.Column([column1],"Vendor Description"), Text.Trim)),",")
@Junaid11 Why not:
Table.Distinct(Table.Column([column1],"Vendor Description"))
@Junaid11 Oh, right, Table.Column returns a list. How about:
Text.Combine( List.Distinct( List.Transform(Table.Column([column1],"Vendor Description"), Text.Trim)),",")