cancel
Showing results for 
Search instead for 
Did you mean: 

using dynamic input on excel files with different tab / worksheet names

SOLVED
Niladri
Meteoroid

Hi Joe,

 

My ask is to load 10 excel sheets ( 7 xlsx and 3 xls) into an Oracle table. In each of these excels, there are three worksheets - A , B and C. I need to load B from each of them. The structure of B is exactly same.

 

Your solution asks us to use Dynamic XLSX. When I put the sheet names that I do not want to use, ( A and C ) , it is giving me this error - The field ' Sheet names' is not contained in the record.

 

Please help.

 

Niladri

Maxholi
Atom

Hi Joe,

 

Is there a way to adjust this macro to be able to read in xls files as well?

 

The xls connection doesn't allow List of Sheet Names.

 

Thank you,

 

Max 

SkyW
Meteoroid

I am also having a problem with .xls files. I have a few workbooks that each contain a single sheet but the sheet name varies from month to month. Is there a way to bring in whatever sheet is available for this file type as well?

Highlighted
Abhi_C
Atom

Joe,

 

Your solution looks interesting. Would it be possible to provide a sample of your solution ?

 

Thanks !

Hello

 

two things from an Alteryx newbie :

 

first, is it possible for the Dynamic Input tool to relay the tab name, not the file name - as a field in the output file ?

I saw a solution online that mimics this, but it only does so by adding a column to each tab's dataset first, with the individual tab name shown in every cell..

far from optimal, especially if the tab data is automatically generated and you want to avoid an intermediate step/formula

 

second, I have set up a dynamic input tool and get the schema error everyone talks about

It seems that either Alteryx incorrectly assigns a string type to V_WString when the same field on all the other tabs reflects V_String

Initially I though there were character(s) in that one column that Alteryx just does not like

however, that seems strange since everyone seems to get the same issue with a Dynamic Input 

 

any ideas ?