join and formula

Hey! i have an excel spread sheet with people id's. one is last months and another one is this months. my question is how do i join them together with join tool for this formula: =IFERROR(VLOOKUP(E54,'January'!$E:$E,1,0),"Left on January") i believe it has to be done with if IsNull([ID]) then 'Left on January' else [ID] endif but the joining is what triggers me /

join and formula.xlsx

Join

Expression

Accepted answers

Emil_Kos

Hi @Crypto_raccoon,

No worries I am happy to help.

Maybe this will work.

If I am not mistaken the first version of this file should work for you:

but if will not check the second one

Join 2 (1).yxmd

Join 2 (2).yxmd

All comments

Emil_Kos

Hi @Crypto_raccoon,

Not sure if this was a reuirment:

This is the output:

If I am missing something please let me know!

Join 2.yxzp

Crypto_raccoon

Thank you, i have just realised that i've been using old version of Alteryx and couldn't check it just yet but i think that is it!

Crypto_raccoon

i am sorry to bug you once again @Emil_Kos however after trying to open it and reinstalling alteryx i get the same message

Failure to Import C:\Users\3\Downloads\Join 2 (2).yxzp.
There was an error opening "C:\Users\3\Downloads\Join 2 (2)\Join 2.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx.

although my version is

AlteryxInstallx64_2020.4.5.12471

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703