Compare tables - option to ignore order?

[alistairhay]

Hi,

I’ve been using the Compare Tables function recently and it’s been really handy, but wondered if there could be the option to ignore the order of the records? The occasions I’ve been using it for is just to see whether both tables have the same records (not just based on an ID, but the full detail), regardless of the order they’re in. Sometimes it’s easy to re-order both tables based on a UniqueID, other times it’s more tricky to do that.

Cheers!

[dgudkov]

@alistairhay

just to see whether both tables have the same records

You can actually do it in a different way:

• Use the "Anonymize/Hash" action to calculate a hash based on all columns for each row
• Use the "Keep/remove matching rows" action to find differences
• Alternatively, sort by the hash column, and use "Compare tables". Sorting by hash ensures the same order in both tables.

[alistairhay]

brilliant, thanks Dmitry