How do I input more than 1 sheet from a file without the intention to combine it?

[Kentwang59]

Let's say I have a file that has 2 sheets (Letter and Numbers) and my goal is to run a find and replace for those against those two sheets. Is there another way to input data without having the need to add two Input Data for the same file on the 2 sheets?

[Emil_Kos]

Hi @Kentwang59,

If the data is in the same format you could be able to use the directory tool in order to load all the data at once but they will be in the same table (you would automatically union them).

Can you tell me why you are exploring different option than using 2 input tools? 

[Kentwang59]

Thank you for responding! They are not the same format. I was more so giving a simple example to illustrate. I have an excel file that has 10+ sheets and I want to see if there's a more efficient way to pull the data in from multiple sheets within the same file so I can perform analysis. 

[Emil_Kos · Accepted solution]

Hi,

You can use the directory tool in order to load may sheet at once.

This article should be helpful. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

It looks like you would use the filter tool to load only a specific sheet at a time. 

[Kentwang59]

@Emil_Kos Thank you so much for the resource. This is very helpful!