The mapping prefix is used to create a mapping table that can be used for e.g. replacing field values and field names during the script run.
It can be put in front of a Load or Select (SQL) statement and will store the result of the loading statement as a mapping table. A mapping table consists of two columns, the first containing comparison values and the second containing the desired mapping values. Mapping tables are stored temporarily in the memory and dropped automatically after the script execution.
The content of the mapping table can be accessed using e.g. the map … using statement, the rename field statement, the Applymap() function or the Mapsubstring() function.
The mapping prefix is used to create a mapping table that can be used for e.g. replacing field values and field names during the script run.
It can be put in front of a Load or Select (SQL) statement and will store the result of the loading statement as a mapping table. A mapping table consists of two columns, the first containing comparison values and the second containing the desired mapping values. Mapping tables are stored temporarily in the memory and dropped automatically after the script execution.
The content of the mapping table can be accessed using e.g. the map … using statement, the rename field statement, the Applymap() function or the Mapsubstring() function.
The Aggr() function is not an aggregation function. Read more about aggregation functions like Sum() and Count() on It’s all Aggregations. Read more about the Aggr() function on AGGR....
.png "Former Employee"){kind=icon}
