Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached.
Done!
@BS_THE_ANALYST Can you explain about the last tool? I can't find that one
Hi @Diwan it's a tool which is part of a larger collection of Alteryx goodies called "Crew Macros". I'll let you google them if you want to find out more about them. You can download this particular one here: https://marketplace.alteryx.com/en-US/apps/419776/crew-expect-equal
Simply put the tool checks two different datastreams and tests if they're equal i.e. Column Names, Values within the columns, and Row Order. I use it a bunch for Weekly Challenges to check my answer. Alternatively, you can just use a join tool and join on every column to check if the two datastreams are equal.
Hopefully that's useful!