Alteryx not reading all CSV files

[Joker_Hazard]

Hello all.

I am having trouble with Alteryx. Its not reading all my 12 CSV files, just the first three. I know there is a limit, however, the first three files only have 1MM rows, which is nothing for a program like Alteryx.

Can someone help me to fix this issue? Thank you very much.

As you can see, the directory tool is able to read the 12 files but the dynamic Input is the one that is not processing all of them...

Each file represents a month going from january to december.

[Luke_C · Accepted solution]

Hi @Joker_Hazard 

It looks like the 4th file has an extra column compared to the first 3, TP_FUNDO. Because of this alteryx doesn't read it because it has a different schema. I swapped in a quick batch macro that will handle this 

[Qiu]

@Joker_Hazard 

As @Luke_C , there is a schema issue for your files.

You may get some idea from this newly post, though it is for Excel Sheets, but the concept is similar.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/File-quot-x-quot-has-a-different-numbe...

[Joker_Hazard]

Thank you very much guys 🙂 

Happy to know that...

Enjoy your week... cheers from Brazil