Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
WF Incremental Loads - Multi Column Load — Cloud Customer Connect
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

Accepted answer
28
Views
9
Comments
edited Feb 19, 2020 5:59PM in Planning 9 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!