Intermediate Mapping Example
In this article, we will cover how to create Intermediate Mapping using our Data Mapper tool. As in our "Basic Table Mapping Example" article, we will illustrate step-by-step instructions and provide a sample file for you to practice. Prior to completing this example, we recommend reading Data Mapper - User Manual and Basic Table Mapping articles.
As in our previous article, you would need to create Intermediate Table FileBox and then navigate to Data Mapper. Then you will select or create a new table and select Dimension Table.
In Header select columns A1 - E1:
In Dimension, only select F1 and press Done:
Then you will rename this cell to "Period" and enable the "Repetitive" function, which will automatically select additional cells and newly added ones. Remember that this function can only be enabled, after clicking Done.
Now we want to add an additional column that will split the data within Subaccount and remove Total G&A Expense. The addition of Custom Column is done by clicking on Advanced mappings.
Select Custom Column and press "Add"
Selecting "Add Custom Column," will open a new window.
Within this window, we will name our new column and enter our desired formula. A full list of supported formulas can be seen in Data Mapper - Custom Calculated Fields.
In Name (map to) you will enter "Category"
Then enter "Split( [Subaccount], ' ',1)" in Formula. Fields are added by double-clicking on them. Followed, by OK.
Within "Category" column we see that "Subaccount - Food Cost" is now showing as "Food"
"Total G&A Expense" is removed by selecting Table Footer, within Advanced mappings.
Select B8 and Done
Press "Publish & Scan Latest Version" and you are done.