Tool that does the opposite of Join.

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.

Datasets

Join

Accepted answers

PhilippK

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/322917

All comments

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703