I am attempting to replicate the following process from Excel into Alteryx:
Table_1:
Table_2:
Join/Lookup I need to replicate:
Essentially the Key get's replicated using the VLOOKUP, but I am unsure how to do this in Alteryx I tried using the JOIN/APPEND Tools so far.
Hi @Andrew_Seaman,
This is one solution that you can use:
The only difference is the output for the empty position it will just stay empty instead of 0
To my best knowledge, you cannot use approximately join as in the vlookup. My approach was to create a row for each of the value of the index.