Batch Macro only reading one CSV file

[FreddieBorg]

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. 

[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

[binuacs · Accepted solution]

@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 

[binuacs · Accepted solution]

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 !