Batch Macro only reading one CSV file

Hi,

I am trying to create a batch macro that will bring in all data from different CSV files and bring them into one file, each with a different schema.

When creating the batch macro to run through of the files using a wildcard function it only seems to be picking up data from one CSV file. Does anyone know a possible solution to this.

Below I keep getting the error about having a different schema and that it will be skipped. how do I correct this.

Batch Macro

Accepted answers

binu_acs

@FreddieBorg in your maco open the Interface designer (Ctrl+At+D) and change to the below settings

binu_acs

Seems to be inside the batch macro input tool you are using the wild card to read the files, you don’t need wild card character with batch macro, change the * and give the full path

All comments

alexnajm

Is this all in one file? If so, which is the workflow that has the batch macro you are building?

Id just grab the macro from here: The Ultimate Input Data Flowchart

binu_acs

@FreddieBorg in your maco open the Interface designer (Ctrl+At+D) and change to the below settings

FreddieBorg

Yes I have already done this ,

still recevining the warning message that some files have a different schema and will be skipped

binu_acs

Seems to be inside the batch macro input tool you are using the wild card to read the files, you don’t need wild card character with batch macro, change the * and give the full path

FreddieBorg

Thanks got it to work !

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280