• Products
  • Get started
  • Documentation
  • Resources

Data Manager - Transform functions

Assets Data Manager for Jira Service Management Cloud is currently rolling out in Open Beta and will be available to all Premium + Enterprise sites by end of October 2024.

Transform functions are short sections of code that can be added to a job to modify the raw data as it’s brought into Data Manager. No functions are enabled in Adapters by default, but there are nine functions in Adapters that can be added to jobs.

A function added to a job will be run when that job runs.

You cannot use a transform function until a job has been run at least once to upload the data from the Adapters client.

Typically, functions are added to a job to clean up or improve the formatting of fields that are being copied from a data source. For example:

  • A field holding the amount of memory for a device might be enhanced by adding a Set Column Type function to change the data type as Big Int so that field can be searched or filtered later.

  • A field holding hostnames from VCenter might be cleaned by using the Remove Right Substring function to remove all of the trailing information after a period.

Transform functions and Cleansing functions are not the same!

Types of Transform functions

Transform function

Purpose

Comments

Remove right substring

Removes the right hand side of a delimiter from a string field.

The column or attribute name that is impacted must be specified.

Replace String

Replaces an old character with a new character in a string field.

The column or attribute name that is impacted must be specified.

Add DateDiff Column

Adds a column to the table containing data retrieved from the data source and fills it with the number of days between the specified column and a base date

The column or attribute name that is impacted must be specified.

For the difference to be calculated, a base date needs to be specified in dd/mm/yyyy format.

If the base date is not specified, the function uses the current date.

Calculate IP Subnet Range

Converts the subnet to CIDR long range.

The subnet column name of the table needs to be specified. This is the table which contains the data retrieved from data source.

Convert String to DateTime

Converts a string field to a date time field.

The date format of the source column must be specified. The format you select must be from the list of formats compliant with Microsoft.

Rename Column With Right String

Renames an existing column. In doing so, it also matches the old column name partly from right-hand side.

As an example suppose you already have a "OperatingSystemVersionNumber" column and you want to change it to "OSVersion". One option you have is to type down the complete names, the other option is by just entering "VersionNumber" (as the rightmost part of the old name) and set "OSVersion" as the new name. So, the system finds out that there is only one column ("OperatingSystemVersionNumber") which has "VersionNumber" as the rightmost part, and it renames it to "OSVersion". If there is more than one column matching, only the first found one will be renamed.

Set Column type

Sets that data type for the column/field/attribute in a table. This is the table which contains retrieved data from the data source

The column name and data type need to be specified.

Discover Locations

Adds the location data to the table. It is based on IP analysis of the job that produces the subnet/sites and services table.

The subnets job name must be specified.

Replace with Null

Replaces a column/field with NULL value.

The value(s) to be replaced with Null and column name must be specified.

Multiple values need to be separated with a comma between them.



Still need help?

The Atlassian Community is here for you.