Transform Map Functions

The Function Picker is a collection of powerful operations for your data model transformation. Select and apply these data transformation operations while mapping data from your vulnerability assessment vendors to the Qualys ETM. For example, you can combine multiple text strings using Concat, convert date formats using formatDateTime, or manipulate text case using toUpperCase/toLowerCase functions.

This page helps you understand what each of the functions are capable of and how you can utilize them for your data modifications.

Supported Functions

Concat

Combine multiple text strings into one. Example: "Critical" + "Risk" > "CriticalRisk".

Split

Separate a text string into parts. Example: "name.surname" > ["name", "surname"].

Replace

Substitute specified text with new content. Example: "High Risk" > "Critical Risk".

Lookup

Find matching values in a reference table. Example: Map "C" to "Critical" using reference data.

Trim

Remove leading and trailing whitespace. Example: " Asset " > "Asset".

Addition

Sum up numeric values. Example: 5 + 3 = 8.

Subtraction

Calculate the difference between numbers. Example: 10 - 2 = 8

Multiplication

Multiply numeric values together. Example: 5 × 3 = 15.

Division

Divide one number by another. Example: 10 ÷ 2 = 5.

formatDateTime

Convert date and time to a specific format. Example: "2024-10-20`" > "October 20, 2024".

RegexMatchReturn

Extract patterns using regular expressions. Example: Extract "CVE-2024-1234" from text.

RegexReplace

Modify text using regular expression patterns. Example: Replace all dashes with dots.

toUpperCase

Convert text to all capital letters. Example: "warning" > "WARNING".

toLowerCase

Convert text to all lowercase letters. Example: "WARNING" > "warning".