Forum Discussion

grggmrtn's avatar
grggmrtn
Icon for Post Patron rankPost Patron
5 years ago

Remove duplicates without breaking query folding?

Is there a way to remove duplicates without breaking query folding? I need the folding (for incremental refresh), but I have a ton of duplicates (I go from 3 0378 271 rows to 10 472 after removing du...
Need Help
justinh's avatar
justinh
Icon for Advocate IV rankAdvocate IV
5 years ago

grggmrtn amitchandak 

I could use this as well, did you ever find out how to do this? 

 

Table.Distinct() breaks the fold. How do we tell the servers to return a distinct list after all our previous steps? 

justinh's avatar
justinh
Icon for Advocate IV rankAdvocate IV
5 years ago

Never mind. Table.Distinct() only breaks the fold if you use it to remove duplicates from a subset of the tables columns, instead of the whole table. Using Table.Distinct() on the entire table does not break the query folding.