Forum Discussion

supermulder's avatar
supermulder
Frequent Visitor
8 years ago

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_Deckler's avatar
    Greg_Deckler
    Community 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?