Forum Discussion
Conditional table combine
Hi thanks for all the replies, I have found an alterntive way of doing this that works - please see Re: Removing rows where there are duplicate fields - Microsoft Fabric Community.
Hello 83dons
try this in Power Query , adjust it in advance editor
let
CurrentUnique = Table.Distinct(Current, {"Role-Number"}),
LeaversUnique = Table.Distinct(Leavers, {"Role-Number"}),
LeaversFiltered = Table.SelectRows(
LeaversUnique,
each not List.Contains(
CurrentUnique[Role-Number],
[Role-Number]
)
),
Combined = Table.Combine({CurrentUnique, LeaversFiltered})
in
Combined
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
pankajnamekar25 I got to this stage but the final table seems huge it is timing out on just counting the number of rows? Are you sure this isnt creating something with a loop too big? Curently at 700MB and still loading the rows and the original files are under 5MB in size so this cant be right for the new table. I am worried this file is far bigger than it should be if I cant even scroll to the bottom of it!
The first two unique tables generate ok its the leavers filtered one that is timing out.