Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove dublicates from Text.Combine ??

Hello,  I need to remove dublicates from my grouped data. But how? Thanks in advance  
Need Help
Show and Tell
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    Text.Combine(List.Distinct([Werk]))

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

Another way is to filter rows according to Werk column string length after grouping. Duplicated rows have longer strings than others. 

= Table.SelectRows(#"Grouped Rows", each Text.Length([Werk])<=4)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.