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 

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 : )

Not first row.yxmd

Sales.xlsx