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

[Data Integration] the way to import multi multi-column type data

Summary:

Hello

In Data Management, if members of the same dimension were arranged in columns, data could be imported by having a column definition in the data field at import format setting.

The following is an example of data to be imported: columns 2-4 are of the same dimension (Account).

---------------------------

Entity,ACCT1,ACCT2,ACCT3

Entity01,100,200,300

---------------------------

To import data in this format, the following options were defined for the import format.

---------------------------

Driver=Account;Column=2,4

---------------------------


What settings should be done in Data Integration to import data like this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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