Commonly used mapping functions

Commonly used mapping functions

Here is a list of the most common mapping functions:

Strings

  • & - To add two fields together

  • & " " & to add two fields together with a space

  • & "," & to add two fields together with a comma

Numbers

  • + - to add two numeric fields together

  • - - To subtract two numeric fields from each other

  • / to divide two numeric fields

  • * to multiply two numeric fields


    • Related Articles

    • Map data from source to target

      A mapping enables you to define the columns to upload from your original file, and map them to the required fields. The gather360 tool also enables you to create expressions and formulas to transform the structure of data at the mapping stage. This ...
    • Building Rules

      An overview of rule-building on gather360. What are rules? The gather360 rules engine offers a range of ways to apply data governance and business rules to prepare and transform data into a report-ready format. In this article, you'll find ...
    • Upload data as a data consumer

      How data consumers can upload data This flow is primarily used by data consumers who do not require a supplier to upload data on their behalf. Usually, the consumer will already have access to the data that has been previously sent via email or SFTP ...
    • Creating a dataset

      How to build your first dataset in gather360 To enable gather360 to prepare and request data for your organisation, you must define the target state for the data that you need. To do this, you must create a dataset. A dataset specifies the target ...
    • Manage data bottlenecks

      Manage data bottlenecks Help your data suppliers to understand data requirements so they can submit data on time. The gather360 KPI dashboard enables users to identify bottlenecks that are increasing your data preparation time and slowing down your ...