importing files with different columns into one file

Hello dears, I'm trying to import multiple excel files in one file in alteryx by choosing a directory then adding the input dynamic after that I choose a file on the input data source template , choose the read list of data source field : FullPath and action is change file/table name

I usually got an error because the data types and the columns are not aligned with each other with the error message below :

Dynamic Processing

Interface Tools

Accepted answers

All comments

randreag

Hi @Malek22

Yes when you have differences in your files the method that youar using doesn't work

I attached here a macro where you have to send the fullpath of the directory.

I hope it helps

LeerArchivosxlsx.yxmc

pedrodrfaria

Hi @Malek22

I have attached a package with the workflow below and the Macro that opens files with different schemas at the same time. See below for an example:

In the example above I have 3 different dummy files with different schemas. I also attached them for educational purposes.

This one is for xlsx files, please let me know if you are working with different files. The process to create one is super simple.

Pedro.

importing files with different columns into one file.yxzp

New Microsoft Excel Worksheet 1.xlsx

New Microsoft Excel Worksheet 2.xlsx

New Microsoft Excel Worksheet 3.xlsx

Malek22

Hi @randreag

It doesn't work with me , I have added directory file, then file path plus the sheets and the macro with my files , the issue appears with the dynamic input again

Malek22

Hi @pedrodrfaria ,

I have proceed with what you have done and it doesn't work with the dynamic input it showing to me the same error

Pablo-GP

Thanks Pedro! This will help with a lot of headaches. Also, it is really straightforward to modify to read CSV directories.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703