Issue with Control Parameter Tool - Reading multiple Excel sheets with varied schema

[Georgealex]

Details of the Job

The Job utilizes the Control Parameter to read multiple excel files with varied schema sheets.

The job runs fine for the excel files where the headers are in Row 1

When the headers start at Row 2 and there is comments in Row 1 , then the job is failing to start reading the data from row 1 instead of Row 2 even after

specifying in 'Input' to Start Data input on Line -2 '

I am attached the images of the jobs and parameters selected.

The First job runs fine with the control parameter(macro) and reads from Row 2

However when the macro is called (inserted) in the second job, the sheet is read from the Row1 instead,

I need help to fix the job to start reading the file from Row2 instead of Row1 in the calling job.

Please let me know if you need more details

Thank you

[acarter881]

Hello, @Georgealex.

Would specifying the import row be a solution? This can allow you to explicitly state which row the Input Data tool uses.

Please see the screenshots below.

[Georgealex]

Hi Carter,

I have specified the same as row 2. The macro job runs with correct output at row 2.

However the job calling the macro , shows that when the macro runs inside the calling job, it gives the data as row 1