I could not find the advance join function in the link provided. Could you please let me know if we could join the Text of two similar column from different files using Join or any other tool. Vlookup Plus joining text of cells. Thank you for all your videos.
Hi Nirmal, it looks like the tool was updated and moved to this URL: gallery.alteryx.com/#!app/Advanced-Join/5d92671b826fd30b8453779e Yes, you can use a Join tool to replicate the VLOOKUP function on text fields. ~ Nathan
Hey Nathan, Thank you for the helpful video. Is there a way to use advanced join or some other way with multiple columns join and conditioning? Regular join tool with left outer won’t work for me. Thanks in advance! Adnan.
Hi Nathan, data import is most important. There is the dynamic input tool in alteryx to get all data in folders with similar structure. I still struggle with the different kind of options when exactly to use full file path and when file name,... Could you do a tutorial and explain with examples how to configure all these things and when to use what? Thanks and happy easter!
Yes, I just used the Dynamic Input tool for a conversion project last month. Will do, and I'll let you know when it is posted. Happy Easter to you as well!
Super useful video and I appreciate your work and shares. Thank you Nathan.
Very helpful Video !! Thank you Patrick
Glad it was helpful!
Amazing...wasn't aware of this before...something new...thanks
My pleasure 😊
Hi,
I'm from Brazil.
Thank you for help me.
Keep up the good work!
I could not find the advance join function in the link provided. Could you please let me know if we could join the Text of two similar column from different files using Join or any other tool. Vlookup Plus joining text of cells. Thank you for all your videos.
Hi Nirmal, it looks like the tool was updated and moved to this URL: gallery.alteryx.com/#!app/Advanced-Join/5d92671b826fd30b8453779e
Yes, you can use a Join tool to replicate the VLOOKUP function on text fields.
~ Nathan
Hey Nathan,
Thank you for the helpful video. Is there a way to use advanced join or some other way with multiple columns join and conditioning?
Regular join tool with left outer won’t work for me.
Thanks in advance!
Adnan.
Hi Nathan, data import is most important. There is the dynamic input tool in alteryx to get all data in folders with similar structure. I still struggle with the different kind of options when exactly to use full file path and when file name,... Could you do a tutorial and explain with examples how to configure all these things and when to use what? Thanks and happy easter!
Yes, I just used the Dynamic Input tool for a conversion project last month. Will do, and I'll let you know when it is posted. Happy Easter to you as well!
Thanks a lot!
Would this be the functional equivalent of a simple join followed the true output of a filter?
Yes, nearly equivalent. I like the theta joins where I can join based on dates or make complex compound joins across varying data types.
Good content, but please get a quieter keyboard - it's very distracting.