Forum Discussion
1 Reply
- dwhansen-cbgContributor
For anyone wondering, I’m using a Join Snap with an Outer Join.
If a unique ID field from the left side is null but populated on the right side then it is a deleted record.
If a unique ID field from the left side is populated but null on the right side then it is a new record.
If a unique ID field from the left side and right side are both populated then the it is an existing record.