How to give vlookup to different tabs at once in Alteryx

[amithkumar070]

I have an excel file with different tabs. Now, I need to give vlookup and need to bring additional columns in all the tabs from another one source file at once using Alteryx. 

All the tabs have one common factor that is employee number. Since, I am new to this and still learning appreciate help on this. 

[cjaneczko · Accepted solution]

Is the structure of each tab different or the same/ if they are the same you can use a dynamic input tool to bring all the data into one tool. If they are each different and the only common thing between them is the Employee number you'd use an input tool for each tab. Then you can use the Join Tool and join each input tool by Employee number. 

[amithkumar070]

Thank you