join and formula

[Crypto_raccoon]

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

[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!

[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!

[Emil_Kos]

Hi @Crypto_raccoon,

I have changed the workflow for you to 2020.1.

I am not aware which version you have but if it will still not work you need to edit the workflow file in notepad and change the highlighted part to your current version

If this was helpful for you please mark my post as an answer!

[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

[Emil_Kos · Accepted solution]

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