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

WF Incremental Loads - Multi Column Load

edited Feb 19, 2020 5:59PM in Planning 10 comments

Summary

How do you do a Multi Column Load with Incremental Process

Content

Hello EPBCS Community,

How do you do a multi-column account load with the incremental load adaptor for WF?

The "Preparing Data Source File" documentation says that you must have an Account column, so this may not be possible?

But if not, then why is a multi column load offered as an option (as opposed to just Deliminated)?

The issue is when setting up the import format, the Data expression can be filled in by selecting which columns are data...but then there is no mapping to the account, because the "Source Column" has to be set. Because the target is Data, there can be only one source column, but the expression calls for 7 different accounts to be used.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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