Forum Discussion

CTan42's avatar
CTan42
Helper II
9 years ago
Solved

Identify duplicates

Hi all, here is my scenario. It is quite complicated. I cant show you the real table, however i made another similar tables. Table 1 (Receive Item): ReceiveID          Item          Payment       ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    CTan42,

    Merge the two tables in Query Editor as shown in the following screenshots.


    Then create a column in the merged table.

    Duplicate = IF(Merge1[RecevieID]=Merge1[Table2.RecevieID]&&Merge1[Item]=Merge1[Table2.Item]&&Merge1[Payment]=Merge1[Table2.Payment],1,0)


    If the above steps don't help, please post more sample data and post your expected result here.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

CTan42,

Merge the two tables in Query Editor as shown in the following screenshots.


Then create a column in the merged table.

Duplicate = IF(Merge1[RecevieID]=Merge1[Table2.RecevieID]&&Merge1[Item]=Merge1[Table2.Item]&&Merge1[Payment]=Merge1[Table2.Payment],1,0)


If the above steps don't help, please post more sample data and post your expected result here.

Regards,
Lydia