We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Start Data Import on Line

CherylH
8 - Asteroid

How can I get my input in options/start data import on line to keep the number I enter?

 

I put it 2, it gets changed back to 1. 

 

Attached file walks through process:  , original file, input file showing various options selected. 

 

Need line 1 to be the header instead of line 1. 

 

Thanks in advance for assistance.

4 REPLIES 4
echuong1
Alteryx Alumni (Retired)

You'd want your configuration to look like this: first row contains data unchecked and start data import on line 2.

 

I attached an example you can use and swap your input file. If you're able to post a sample of your data, I can create a workflow with your data.

 

echuong1_0-1611172048230.png

 

CherylH
8 - Asteroid

When I change data import to start on line 2, the system changes it back to 1

 

Attached is file in exact format it comes in, Excel, line 1, should not import.  Start everything on line 2.

 

 

echuong1
Alteryx Alumni (Retired)

How interesting! What version of Designer do you have installed?

 

I am able to successfully change the import line to 2, and load the data as expected. See attached for the workflow - try running this and see if it works. I also added a data cleansing to remove extra lines.

 

echuong1_0-1611173320817.png

am

CherylH
8 - Asteroid

Not the current version.  Research on here more, seems version I'm using had a bug.  Installing current version.  Let you know if that fixes the problem.

Labels
Top Solution Authors