Trouble importing data from text file
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"