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!

[srhodes1996]

how can i tweak this marco to start import from a certain row?

[apathetichell]

@srhodes1996- that's different value in the input data tool. Find the inner input data tool. attach a new action tool. attach a new control parameter.

set up the new action tool to update the part which tells it to what line to bring in your data from. feed in this value in your control parameter.

In the alternative -> in your inner macro:

use a record id.

use a filter to find the header row using the logic you know. isolate that record id.

append that one thing to your datastream. use a filter to find that row and the rows after.

use dynamic input to take column headers from the first row.

continue with your data.

[dvkbalaji]

How to write these multiple sheet into another excel ?