Applies to Data Academy 5.6+
Data Academy MAP-it allows you to "map" data from one relational table to another.
Imagine this scenario:
You have a pre-compiled report which requires input data from a SQL table defined as follows:
CREATE TABLE [Order Report] ([Order Date] datetime, [Customer Name] varchar(100), [Product Name] varchar(50))
Your mission (should you choose to accept it) is to "map" the data INTO this table FROM your source tables.
If you think about it, this is a bit like running a conventional TRANSFORM-it operation, but into an EXISTING table; and the good news is that it does indeed work in very-much the same way.
Creating A Map Space
Starting off, you need to create a "Map Space" which will contain your mapping operations.
Adding Table Mappings
When you drill-in to the Map Space Details screen, you can add a mapping 'From Table' X 'To Table' Y - in this example we are mapping from the DL_Order table to the [Order Report] table required by our report.
Adding Field Mappings
In the Mapping Details screen, you configure which fields (columns) in your source table map to which fields (columns) in your target table.
Adding Joins
If you need to join-in additional souece tables, this is done in exactly the same way as with TRANSFORM-it.
Field-Level Transformations
If you need to re-shape the data, then you can use a Field Function just as you would in TRANSFORM-it.
In this example, we want to combine the First Name and Last Name fields and map them to Customer Name.
First, add the mapping from First Name -> Customer Name.
Then drill into the details to pull-in Last Name via a Field Function.
