Multi-Column numeric data load in FDMEE 11.2.2

In my last blog, I showed how to load multi period data - but in a single numeric column. In this blog, I will cover loading a multi-column numeric data file.

Here's my source file (make sure it's in '.csv' format if you're using MS Excel):

I'm using an excel data file with multiple columns of numeric data to a period as a column header. 

Note: The Excel file may or may not contain a header.

Let's get started.

In the last blog, I already registered the target application ('POC') and created a source system ('File'). So let's head over to the Import Format section.

I will create a new import format.

File Type: I have chosen 'Multi Column - Numeric Data' because I have multiple columns of numeric data.

Save it.

Now let's update the mappings.

In the source file, we have the following dimensions:

However, we DO NOT load/map Scenario, Period and Year in our import format. Those are taken care in category and period mapping.

As per the sequence of the columns, I mapped the dimensions:

Let's do the Amount column mapping now. Amount in my source file starts from the fifth field.

Hence I will mention the field number as 5 and save it.

Now, we need to tell FDMEE that we have multiple amount columns. For amount, click on the pencil icon under 'Add Expression'. You'll get the below window:

From the 'Expression Type' drop down, select Column=start,end.

You'll get the below window:

Expression Type: 'Column=start,end' is already selected.

Expression Value: The data in the source file is between columns 5 and 7. The format 5,7 defines this range.

Click on 'OK'.

Save it.

Let's create a new LOCATION for this load:

Save it.

Please ensure you have the necessary -

• Period Mappings
• Category Mappings
• Data Load Mappings

Please refer my previous blog for more details on these.

Let's create a DATA LOAD RULE.

I have selected the below POV:

Created the below DLR:

Below are the 'Target Options':

Select the DLR and click on 'Execute'.

Click on 'Run'. Below process initiated:

Let's check the process details - It shows as successful:

Below are the process steps that clearly shows the data being imported for the individual months:

Let's head over to DATA LOAD WORKBENCH.

I've selected the required POV:

I can see the data imported accurately:

I verified the same for Feb & Mar as well - all imported just fine.

Now, let's load them. Click on 'Export' in the above screenshot:

Click on 'OK'. Process initiated:

Data is loaded for 'Jan':

Next, I loaded for 'Feb' & 'Mar' as well.

Loading complete ✔