Different Schema erro in using Dynamic Input

Hi all,

Recently, i"ve just done a quiet easy logic in Alteryx:

1. Use 'Dirctory button' to locate a folder;

2. Use 'Dynamic input button' to change entire file path;

3. Do some data cleaning;

4. Union all the files in this folder.

But When i run the logic there is an error in 'Dynamic input' saying that the schema is inconsitent with the first file.

Though, all my input file is .xlsx---directly extrated from ERP system

Any ideas or instructions?

I've attached screenshot in the word for your reference.

Hope your guys could help me to handle this.

Best regards,

lakt

Accepted answers

Thanks a ton.

This really helped me save a lot of effort while automating.

Do you have multiple sheets in these xlsx files?

Best,

Jordan Barker

Solutions Consultant

Hi JardanB

Thanks for ur reply.

Not yet, one tab in one excel Smiley Mad

Regards,

laky

Do you have any idea about this, Jordan?

Cuz i just tried that if i use several 'input file' button, then union them, it does work.

So i think the painpoint is about the Dirctory & Dynamic input

Regards,

Laky