Checking your work on the drills

[mlayten]

After doing lots of drills and manually checking my work I just figured out a quick way to check my answer vs the solution and figured I'd share 🙂

Union your answer and the target together (default settings is fine) and then do a unique (Preparation last icon - snowflake) on the union with all columns selected.  You should get the same number of rows in unique and duplicate.  If you don't, look closer 

[Jean-Balteryx]

Hi @mlayten ,

There is a simpler way : using the Expect Equals tool from the CReW Macro Pack. It compares what you expect and your actual data then tells you the differences.

This pack is available following this URL : http://www.chaosreignswithin.com/p/macros.html

Cheers,

Jean-Baptiste