Batch Macro - reaading multiple input files

[sneha_bhiwagade1]

Hi Team,

I have a batch macro which reads 50 input files. 

 

refer the above screenshot of my batch macro. As in each  50 files data is not present on same line number that's why i have created above match macro. (by checking the condition of empty column and then reading the headers from first row of data)

Now in 50 input files in some files there is mismatch in header names 

for example in some file the headers is "Roll NO" (with space ) an in some file I a getting the header without space as "RollNO".

Is there any alternate way to fix this and read both file dat under one header. 

or is there any way to inform users that the respective file headers are not correct or there is space in headers.

Many Thanks in advance!!

[gawa · Accepted solution]

hi @sneha_bhiwagade1 

If you are sure of order of columns are identical for every files, you can specify "Auto Config by Position..." option in Interface Designer, then all data are forcibly combined. Please try it out. 

[sneha_bhiwagade1]

thank you!!  @gawa 

[omkarshinde]

@gawa any way to add filename as extra column with every record while reading multiple files via this batch macro?