Picking sheets

[rajputakansha]

Hi,

I have a set of 8 excel files. I want to import 2nd sheet of each file into Alteryx.

Can anyone tell me how do I achieve this using Directory tool?

Thanks

[DiganP · Accepted solution]

@rajputakansha You can use the macro as described in this article to bring in the data from each file. You can use the directory tool, then the formula tool to turn the file path to the proper full path. The formula would look something like this:

[FullPath] + '|||2ndsheetname'. 

You can then use the dynamic input tool to bring in all the files. 

[rajputakansha]

Hi @DiganP ,

Thanks for your reply.

If I use Directory tool to get 2nd sheet from each file but each file has a different sheet name, what formula should I use in that case?

Thanks