Forum Discussion
supermulder
8 years agoFrequent Visitor
Find the difference between datasets
id, snapshotId, objectName, status
Example Data 1.1,"Test object", active 2,1,"Test object 2", Active 3,2,"Test Object", Inactive 4,2,"Test object 2", Active
Hello,
Assuming I have a table structure like above - how can I display a delta of records where the status has changed between the "snapshots"?
So referring to the above example I want to get the following result
"Object","Status Old","Status New"
Test object, Active, Inactive
thank you
1 Reply
- Greg_DecklerCommunity Champion
If you do a Merge query in M, it allows you to choose the join type. I'm guessing you would want a Right Anti join?