Forum Discussion
Solved
Conditional table combine
I currently am combing a current staff table with a leavers table (last 2 years). They both have identical columns and types. At the moment I am just using a simple 'Append Queries as New' option and...
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.
this is the sample data I used for testing
maybe you can try remove duplicated to remove the duplicated rolenumber
or you can add one step in the leavers table
= Table.SelectRows(#"Changed Type",(x)=> not List.Contains(Current[role_number],x[role_number]))
then combine the table again.
pls see the attachment below