Hello,
I have two sources that store data in the exact same format:
- table ITAM54 --> This is today's data
- savedITAM54 --> yesterdays's data
I need to create a new table that compares the two tables on one column (ID) and ONLY output the differences.
The results I am looking for:
ITAM54 (today) | | | | savedITAM54 (yesterday) | | | | | Expected Output | |
52 | CAT | 4/30/2019 | | 34 | DOG | 4/29/2019 | | 52 | CAT | 4/30/2019 |
34 | DOG | 4/29/2019 | | 65 | CAT | 4/18/2019 | | | | |
65 | CAT | 4/18/2019 | | | | | | | | |
How can I produce this in the Data Load Editor