[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:
0