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

    • 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 ...
    • What is a dataset?

      An overview of the core elements within a dataset A gather360 dataset is a core entity that users can customise within the platform. It contains detailed settings and requirements for your specific data need. These settings define three core things ...