Tool that does the opposite of Join.

[Songbird]

Is there a tool that can analyze a database and identify repeated combinations of information in fields that could be extracted to create a separate lookup table or tables. In the interactive lesson on the Join tool, you join the tree database with the lookup table populated with burrough information. What I'm wondering is if a tool exists that could take the output of that join and break it up into the data streams that were joined, or even to find more comprehensive relationships that could lead to a more compact database with additional lookup tables.

[PhilippK]

Hi @Songbird 

check out the Fuzzy Match tool. It is quite advanced, but powerful to find more comprehensive relationships/joins.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

Best regards

Phil 

[Songbird]

Thanks for the advice. I'll take a look.

Kind regards\ Vriendelike groete,

Markus Kruger

[Songbird]

Hi Phil, thanks again for your reply. I've taken a look at the fuzzy match tool, and I don't quite understand how the tool will link over multi columns to find the correlated blocks.

[PhilippK · Accepted solution]

Hi Markus,

yes it is not easy, but should be possible with Fuzzy Matching - check out those posts:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Fuzzy-Match-Multiple-fields/td-p/61968

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Compare-and-match-multiple-fields/td-p...