You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trouble importing data from text file

Accepted answer
12
Views
6
Comments

When importing data from a text file, I get the following error:

[2] Ignoring data record 2, number of header record fields (1) does not match the number of data record fields (7). Check delimiter setting and record fields.


Can anyone help me understand how to correct this?

Thanks in advance!

jg


This is what the text file contains:

"BegBalance"

"Working"|"BU1"|"15"|"Dept1"|"FY21"|"Current Fcst"|"Account1"


This is the export rule I am running:

Set DATAEXPORTOPTIONS{

    DataExportlevel Level0;

    DataExportDynamicCalc Off;

    DataExportNonExistingBlocks Off;

    DataExportDecimal 16;

    DataExportColFormat On;

    DataExportColHeader "Period";

    DataExportDimHeader Off;

    DataExportRelationalFile Off;

    DataExportOverWriteFile On;

DataExportDryRun Off;

};

Fix("Working", "BU1", "15", "Dept1", "FY21", "Current Fcst", "Account1"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!