Sort All Columns or Easier Way to Match Two Datasets

[trettelap]

So this isn't a huge problem, but just annoying for the most part. The goal is to compare two datasets to determine if they match. To do this, I have been utilizing the CREW expect equal macro. However, for this to work, the data has to be sorted in the same way. although this can easily be done with the sort tool, setting each column manually can get very annoying if working with many columns. Is there an easy way to sort the data in all of the columns? Possibly a macro that would do this?

Thank you in advance. 

[echuong1 · Accepted solution]

There are a couple of ways to match two datasets - using the expect equal Crew macro is one of them.

Another method is to join on every field in your dataset. If there are a lot of fields, this can be a lot of work to set up. Luckily, there's actually been a dynamic workflow already created to do this. See the below article for more information and downloads of the workflow:

https://community.alteryx.com/t5/Engine-Works-Blog/Compare-2-Data-Sets/ba-p/88853

Hope this helps!