Start Data Import on Line

Question

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.

Start on line.docx

CherylH · Answer

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.

echuong1 · Answer

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.

am

New Workflow1.yxzp

CherylH · Answer

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.

Combine files into 1 to bill.xlsx