Compare columns

[rgimenez]

Hy guys,

I need to check the inconsistency of the data between these two tables:

the first is the bank data with the respective IBAN and in the other the data we have in SAP and its IBAN.

The problem is that not even without the names and IBANs match, so I need to find out which sap lines do not match the bank's data.

The two filters I put up are the same, the only thing that each for each company in the group we have a docigo. I did it just to divide it by group company.

[rgimenez · Accepted solution]

Hi Raymundo,

Acctualy I used the EXCEPT.

It worked.

Thanks anyway.

[Anonymous]

Are these tables related? If they are you can create a calculated column with RELATED() to compare two columns or even merging them in Power Query and creating a conditional column.