Dynamic Input of multiple files for specific tab

Hello,

I am trying to combine information from same tab from multiple excel files. In my example, I need Alteryx to find "Analysis" tab in each excel file saved in a given directory and append information vertically. I am using directory tool and dynamic input tool. However, my output takes only one file from the directory. Why other file is not being picked up?

Here is my flow.

Thank you so much,

Anastasia

Dynamic input of multiple files for specific tab.yxmd

Use Tax - Company 2.xlsx

Use Tax - Company 1.xlsx

Dynamic Processing

Accepted answers

randreag

hi @AnastasiaG

the problem is the differences between columns

Please download this macro and connect it after your formula. It would read both files

I hope it helps

LeerArchivosxlsx.yxmc

All comments

afv2688

Hello @AnastasiaG ,

both files need to have the same amount of columns, named the same way and having the same data type, otherwise, those who do not share the same schema will be skipped. By the way in your case the first file has 30 columns and the second 40 and some columns don't have the same data type.

Regards

randreag

hi @AnastasiaG

the problem is the differences between columns

Please download this macro and connect it after your formula. It would read both files

I hope it helps

LeerArchivosxlsx.yxmc

AnastasiaG

Thank you for your reply. How can you tell that they do not have the same schema? They both have the same column names and all columns end on AM.

mceleavey

Hi @randreag , I've built tools for this exact purpose.

I've attached the example workflow along with the tools.

The first tool pulls in the Sheet names, you then append those to the filename. Then the second tool dynamically loads in all files regardless of schema.

Hope this helps.

Multi Sheet Import Example.yxzp

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

AnastasiaG

Macro worked and 2 files appeared, but at dynamic input step, I got error message that record was created with no fields.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280