Inputting and joining multiple excels with only one column in common at once

[iliceva]

Hello everyone,

I have been working on various projects where I came across the same problem repeatedly, and for now haven't found a way to automatize it. So, I'm writing in hope that someone has already done it, or at least have an idea how it could be done.

Thing is that I have a lot of different excels that I need to join. They all have only one (the first) column in common but all others differ. The way I've been doing it is that I use input tool for each excel I have and then use Join multiple. Although it's working, it's really time consuming and I assume that there is a faster way to do it, just it hasn't occurred to me yet.

If anyone has some idea, I'd appreciate it a lot.

Thanks in advance! 😀

[RaviP]

Not sure it would help but you might want to take a look at the below thread

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Join-multiple-excel-files-in-a-folder-...

[iliceva]

Thanks! I apparently somehow missed this post. I'll check it out and let you know if it works.