Load large number of excel files

Hi All,

I have been sent 67 excel files ranging between 4MB to 15MB in size. I have been trying to load the data via DIR and Dynamic Input tool but it appears Alteryx isn't able to cope this is amount of data and gets stuck on the first file.

Does anyone have a suggestion on how I can load the data ?

Thanks in advance

Matt

Snag_2519b881.png

Dynamic Processing

Accepted answers

caltang

No worries @sh_mryan

This is how:

For sh_mryan.yxzp

All comments

caltang

You are using a Directory tool, which only gives you a list of files that are contained in a directory and relevant file attributes.

You need to use a Batch Macro / Dynamic Input to call in all 67 files.

Answer me this:

Are your 67 files of the same structure / data frame? Meaning they have the same Column Names, Column Counts, and Data Types?
From your 67, do you intend to make it one large data set or do you have something else in mind?

Depending on your answer to No. 1, if your structure / data frame is not the same, then you need a Batch Macro configured to call the appropriate names / position / order. If they are the same, you can explore the Dynamic Input function.

Better still, can you provide us some sample data and at least 4 random files from the 67?

Thanks.

sh_mryan

caltang, thanks for responding

Are your 67 files of the same structure / data frame? Meaning they have the same Column Names, Column Counts, and Data Types?

Yes they all have the same structure / data frame

From your 67, do you intend to make it one large data set or do you have something else in mind?

I was thinking of one large data set.

I can't provide sample data due to confidentiality, I have mocked up example of the files look like and the workflow I have been trying to make work.

Note, this workflow examples works because the files are small. When I apply the workflow to the 67 files, Alteryx struggles.

I tried with these two, not working:

Example 2.yxzp

Example1.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703