I get a file that comes in through FTP. It is imported to a table, SQL Node gathers the data. Then 2 text files are created using FileAccess Node and imported with IMDBB via a multi-step job..
This is what I have In the FileAccess Node. The files are created properly.
1st FileAccess Node:
COMPANY,VENDOR,INVOICE,AUTH_CODE,PROC_LEVEL,INVOICE_DTE,TRAN_INV_AMT,CASH_CODE,SEP_CHK_FLAG,PAY_IMM_FLAG,ENCLOSURE,TERM_CODE,REC_STATUS,POSTING_STATUS,DISTRIB_DATE,HANDLING_CODE
<!FinalArrayInvoice.join("")>
2nd FileAccess Node
COMPANY,VENDOR,INVOICE,DIST_SEQ_NBR,ORIG_TRAN_AMT,DIST_COMPANY,DIS_ACCT_UNIT,DIS_ACCOUNT,ACTIVITY,ACCT_CATEGORY,DESCRIPTION,DST_REFERENCE
<!FinalArrayDistrib.join("")>
When the WebRun Node executes the Multi-Step job that imports both files, it gives a message that the "HANDLING-CODE" doesn't exist in the 1st step and "DST-REFERENCE" doesn't exist in the 2nd step.
I've verified the field names in the tables that the files are imported to. The correct names are in the list within the File Access nodes. The job notifies us that those fields don't exist. That's correct, but those field names are not the field names I referred to in the File Access node. The Job is trying to find fields that have hyphens in the names. Interesting that both field names it has a problem with are at the end of the line. I tried adding a semicolon but the job only used that as part of a field name.
