Input Excel Table where file name contains either one or another string

Question

I have a folder with several Excel Files (more than 2).

There are 2 options for the Excel File that I want to import as Import Data.

1) Excel File name contains "*GERMANY*" and Sheet name is "Blatt 1" OR

2) Excel File name contains "*AUSTRALIA*" and Sheet name is "Sheet 1"

Only ONE of these 2 Excel Sheets is ever in that folder.

I want Alteryx to use the one that is there as INPUT Data.

(I know how to use Asterisk to import an Excel Table with "contains in file name" but these are 2 different Excel Sheets)

Can this be done automatically?

Hope this makes sense?

Thanks,

Petra

Qiu · Answer

@pohrt 
Lets do the filtering before importing the data.

0112-pohrt.yxzp

pohrt · Answer

Hello Qiu,

thanks for your quick reply. I could give that a try ... still there might be lots of Excel Sheets in that Folder with all sorts of different Column setups.

I would take some time. then I still need to ask the question with the filter: Does this big file contains GERMANY or AUSTRALIA?

I will play with this but was hoping that I did not have to import all Data from all Excel Sheets.

Thanks,

Petra

GBO95 · Answer

Hi @pohrt ,

This is a great use case for batch macro. In my folder, I have the following files with the respective sheet names that you have mentioned:

In order to read in the files with different sheet names at the same time, you'll need the following string for each of the files. This is how Alteryx reads in the Excel files with specific sheets.

You would do this by using the directory tool and formula tool, after which you can use the batch macro and read in all your files.

I hope this helps! Attached is the sample workflow with the macro.

Best,

Ganesh

Sample_Read Multiple Excel.yxzp