Hi everyone, I need to compare two tables I have, to get the third table. The condition is that If Col1.Table1==Col1.Table2 AND Col2.Table1==Col2.Table2 AND Col3.Table1!=Col3.Table2. For instance: Table 1: Name Category Date 1) X A 1/1/2001 2) Y B 2/15/2004 3) Z C 5/20/2014 Table 2: Name Category Date 1) X A 1/31/2001 2) Y P 3/15/2004 3) Z C 5/20/2014 Resultant Table: Name Category Date 1) X A 1/31/2001 So here in the above example I have only one record in the resultant table where Name and Category are same but Date is different. I need a workflow for this, I tried Math Formula but result wasn't as expected. Thanks.

Compare Two Tables based on Three Columns

mauuuuu5 September 23, 2018, 3:43am 4

The new links are

1 Like