Warning after adding new row into my dataset

I have multiple CSV files that I run my workflow every month to generate a report. This month I added a new company to my data set that does not exist in previous files. I am getting a warning after I added a new company to my CSV that it said "Warning: Input Data (137): The file "G:\...\June 2022\New.csv" has a different number of fields than the 1st file in the set and will be skipped "

That company whit all their data would not appear in my workflow.

Workflow

Input

Accepted answers

Luke_C

No problem, let me know how it shakes out and accept the solution if it's all set.

All comments

Luke_C

Hi @ArvinM

It sounds like you're using a wildcard input or dynamic input to load the data. This requires all of the data to have the same schema, so an additional column will cause the file to not be included since it is different. You should consider using a batch macro to load the data. Take a look at this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Batch-import-files-with-varying-schema/td-p/11049

ArvinM

Hi @Luke_C

Thanks for your help. I looked at the post that you mentioned, before going to try that I want to confirm that I am not dealing with CSV files that include multiple Sheets. I have two files each month and each file has one sheet. for this month I have added a new store at the end of my dataset. do you think the batch macro will be a solution for this?

Luke_C

@ArvinM

Yes, understood that CSVs don't have sheets - similar concept applies though. Batch macro will be your best bet. Can you attach 2 sample CSVs with each format?

ArvinM

here an example of my data set and the differences

Here's an example:

Perfect, Thank you so much!!!!

Luke_C

No problem, let me know how it shakes out and accept the solution if it's all set.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335