Forum Discussion
Solved
Compare what changed in two lists
Hi, I have two tables with IDs and another entry (lets say fruist) which I want to compare (My real tables have thousands of rows with 7 different fruits) e.g. Table1: ID Fruit 1 apple ...
Just do a Full Outer Join and then if then statements comparing your left table to your right table values and where it is null and not null.
if [ID] = [Table2.ID] and [Fruit] = [Table2.Fruit] then...
else if [ID] = null then ...
etc...
This worked, thank you!