Unable to access data from multiple files

[gagandeep_dhall]

Hi Everyone,

Happy New Year to everyone!

I am reaching out to you for an issue I am encountering during fetching info from multiple Excel files.

This is what I am trying to achieve: Fetching information from a particular tab from Multiple Files placed in one folder

Issue: There are 5 Tabs, but for some of the tabs the information is not being fetched. This is how my current output looks:

Tab	Date 1	Date 2	Date 3
Tab 1	Info	No Info	Info
Tab 2	No Info	No Info	Info

I have tried the following options and getting the following errors:

1. Dynamic Input: Does not match  sheet or named range

2. Batch: while using batch, its taking top row from each table in the tab and puts it in my final result, thus throwing off the output completely 

[fmvizcaino]

Hi @gagandeep_dhall ,

Would you be able to share a couple files and a sample data for me to check it out?

Best,

Fernando Vizcaino

[gagandeep_dhall]

Hi,

Unfortunately, its proprietary data and I dont know how to recreate the error it is giving through a dummy file 😞

Regards,

Gagandeep

[fmvizcaino]

Hi @gagandeep_dhall ,

One thing that could be happening is related to the data type of each file. Sometimes when you have a date column with only null values, Alteryx reads as string and it will disregard that tab since the structure of data types is not the same as the template.

Best,

Fernando Vizcaino

[gagandeep_dhall]

Hi @fmvizcaino ,

Can I make sure all the files are converted into the same data type before I fetch the data?

Just another thing, if this was the case, how was Alteryx able to read the files through Batch method?

Regards,

Gagandeep

[fmvizcaino · Accepted solution]

Hi @gagandeep_dhall ,

There is a workaround, I'm attaching an example here.

Related to your second question, the output of a batch macro works as a union tool and it disregards the data type, only considering the header.

Best,

Fernando Vizcaino