Importing an Excel file with Multiple Sheets

[cluk019]

Hello there, 

I was wondering, is it possible to import an excel file with multiple sheets? I have attached a file for reference

Where I would only be using <To be Imported> tab's values to work out a formula as per <formula> tab?

Thanks!

[TimN]

Hi,

Yes.  If the sheets have the same schema - same structure - then it's easy.  If each sheet is different then it can be done with a macro.  

[TimN]

Here's a good link to look at.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

[Felipe_Ribeir0]

Hi @cluk019 

Yes, it is possible. Take a look at the attached workflow

1) Configure the input tool to export the sheet names and the file name

2)Use the formula tool to generate the full path for each sheet name

3)Use the dynamic input tool OR the batch input macro to import each sheet to Alteryx

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[cluk019]

Hello! Thanks for replying!

I understand your workflow completely, but can I just upload a file (which has 3 tabs) but I only want to import 1 tab, which is the <To be imported> tab?

Can you please guide me how?

Thanks!

[Felipe_Ribeir0]

Hi @cluk019 

You can use a filter tool to keep just the sheet/sheets that you want to import:

[mjoshi043]

This was Great!