Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

Georgealex
7 - Meteor

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

 

2 REPLIES 2
acarter881
12 - Quasar

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.

 

acarter881_0-1686936825478.png

 

acarter881_1-1686936936831.png

 

 

Georgealex
7 - Meteor

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

Labels
Top Solution Authors