Issue reading Excel File as data source - Start Data Import on Line

[glombard]

When the user runs the report from Alteryx server, she is getting the following error message:

So I have to open the file:

As you can validate the column headers are not ok

Then I have to change the “Start Data Import on Line” from 2 to 1

Now the column heading is correct.

But in the new file generated by the source system I have to change “Start Data Import on Line” from 1 to 2 in order to get executed the report.

this switch has to be done every time that a new file is generated by the source system.

How can avoid this on every new file generated from the source system?

[atcodedog05]

Hi @glombard 

Can i know which version you are using?

[glombard]

Hi @atcodedog05 

Here is the version that I'm using:

Regards,

Gilberto

[atcodedog05 · Accepted solution]

Hi @glombard 

Here is how you can it.

Workflow:

1. Import data using input tool with configuration "Input tool contains data"

2. Use filter tool to filter rows.

3. Use dynamic rename to take name from first row.

4. Use Auto-field or select to convert data type.

This way it automatically finds where the data is and starts reading from here.

Hope this helps : )

[atcodedog05]

Hi @glombard 

I am using 2021.1 it seems to have a feature where it auto-detects the start of the table by itself. Just discovered it today 🙂

[glombard]

Hi @atcodedog05 

thank you so much for your help.

This resolved the issue with the report.

Have a nice day.

Regards,

glombard

[atcodedog05]

Happy to help : ) @glombard 

You too have a nice day 🙂