Issue with Control Parameter Tool - Reading multiple Excel sheets with varied schema
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Help
- Iterative Macro
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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