Reading Input files

Question

Hi All,

I am reading 50 input files through a batch macro.

But for some files we are getting the headers on different  line number.

is there any way to dynamically read the files from different line number.

Or is there alternate way to inform users that headers are on different line  in so and so file that's why this file is not read in our batch macro. (message)

Many Thanks in advance!!

dhrathod · Answer

please accept as solution - if it worked

binu_acs · Answer

@sneha_bhiwagade1 One option is to update your batch macro input file tool to like the one below, this will allow the batch macro to have the same header records for all your input files then with the help of the Filter tool you can exclude the records that you don't want to

dhrathod · Answer

You can modify the macro:  add a filter post input tool to filter out the lines from top of the data (you will need to identify a column which has null data) then add a dynamic rename tool using first row as header

That should work.

Do not use the option to read the data from specific line.