How to Load Multi-Column Data Load in Data Management

 If we get data in multi columns, for example as below:

We can use Multi-Column Numeric Method to load this for all months in one shot.

Mainly, Set below option as Multi Column - Numeric Data in Import Format.

In Import Format, Mappings, we need to specify Period Columns and mention as Driver name as Period

Now, Create Data Rule with above created Import Format.

To Mention Period - We will get an option like below as Column Headers

Here, we can select period as per columns in the Source File. In Target Options also Numeric Data only is fine. 

Note: If we change this option, can't get back Numeric Data Only option. Think twice before changing this option.

Now, We are set to load data, Update Data Load Mappings and Execute the Data Load Rule.

Thanks,

Mady