Help regarding input tool.

Hi All,

Can someone please guide me on how I can extract data from multiple tabs of an Excel sheet using a single input tool? Currently, when I connect an Excel file to the input tool, it asks me to select either of the tabs, but not multiple at a time.

Please advise if someone knows the solution.

Input

Accepted answers

DataNath

Hey @anonymous008_G, there's a knowledge base article here outlining the steps you'll need. If you have sheets with the same schema then you're going to want to follow option 2 and if not then take a look at the batch macro - option 3:

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

All comments

DataNath

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

anonymous008_G

Thanks for the article, seems like article is about how we can import multiple files using wildcard or macro but in my case I have one excel file with two different sheets and i want import data from both of these sheets using one input tool. Is it possible?

aatalai

@anonymous008_G if they are the same schema, have you tried the dynamic input tool?

anonymous008_G

Thanks Guys, dynamic input tool works for me

aatalai

@anonymous008_G glad to help could you mark my post with the dynamic input tool as the solution too please?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703