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

loading multi-column Numeric data as amount

Summary:

loading multi-column Numeric data as amount

Content (please ensure you mask any confidential information):

We have a source file with a receipt and payment column that we need to load into one amount column in ARCS Transaction Matching. The file has a header row. We tried setting up the file as Multi-column - Numeric Data type in the Import Format. When executing the data load integration, the process fails with errors. Do I use the Expression Type 'Column=start,end' or 'Driver' when I have a header row?

For example, when receipt column has 1000.00, the payment column has 0.00 and vice versa.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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