Convert functions

Convert functions can change the data in a placeholder from one type to another.

Boolean

Converts data from an unspecified data type to Boolean data type.

{$.inputs.currentAddress} = true

{boolean:{$.inputs.currentAddress}} = true

Country to ISO

Converts a country name (English) to its two-letter ISO code.

{$.inputs.country} = Canada

{countrytoiso:{$.inputs.country}} = CA

ISO to country

Converts a two-letter ISO code to the corresponding country name (English).

{$.inputs.ISO} = CA

{isotocountry:{$.inputs.ISO}} = Canada

Domain

Extracts the domain name from the website URL.

{$inputs.website} = https://help.qlik.com/

{domain:{$inputs.website}} = qlik.com

Flatten

Flattens an object with nested properties to a new object without nested properties.

{$userInfo} =

{
  "name": "John",
  "address": {
    "city": "Paris"
  },
  "orders": [
    {"id": 55},
    {"id": 66}
  ]
}

{flatten:$.userInfo} =

{
  "name": "John",
  "address.city": "Paris",
  "orders.0.id": 55,
  "orders.1.id": 66
}

Host

Extracts the host name from the website URL.

{$inputs.website} = https://help.qlik.com/

{host:{$inputs.website}} = help.qlik.com

National Phone

Normalizes a phone number into a national format by removing the international code.

{$inputs.phone} = +1 (529) 866–7788

{nationalphone:{$.inputs.phone}} = 5298667788

Phone

Normalizes a phone number into an international format. A two-character ISO country code parameter is required.

{$inputs.phone} = 498667788

{phone:{$.inputs.phone}, 'FR'} = +33 4 98 66 77 88

Number

Converts data from an unspecified data type to number data type.

{$.inputs.age} = 55

{number:{$.inputs.age}} = 55

Object

Converts data from an unspecified data type to object data type.

{$.inputs.age} = 55

{object:{$.inputs.age}} =

{
    "age" : "55"
}

List

Converts data from an unspecified data type to list data type.

{$.inputs.age} = 55, 65, 75

{list:{$.inputs.age}} = [55,65,75]

JSON

Converts an object into JSON text.

{$.inputs.age} = 55, 65, 75

{list:{$.inputs.age}} = [55,65,75]

When the $.path value is a list with three items, for example, the result will be text such as "[ one, two, three ]"

{$.path} is a variable of type list or a list that is returned by a certain block.

{json: {$.path}} = [ one, two, three ]

CSV

Converts a flat JSON object with key-value pairs into a single CSV line. You can optionally enter the columns and delimiter as parameters.

{$.inputs.userName} = {name: John Doe,location: New York}

{csv: {$.inputs.userName}, 'name, location', ','} = John Doe,New York

The CSV convert function preserves the order of columns in the CSV file for multiple objects.

{$.myObject1} =

{
  "key3": "val 003",
  "key1": "val 001"
}

{$.myObject2} =

{
  "key1": "val 011",
  "key2": "val 022",
  "key3": "val 033"
}

{$.myObject3} =

{
  "key1": "val 111",
  "key2": "val 222"
}

{$.columns} = [ key1, key2, key3 ]

Apply the following CSV formulas:

{csv: $.myObject1, $.columns} {csv: $.myObject2, $.columns} {csv: $.myObject3, $.columns}

The CSV convert function returns the following table:

"val 001",         ,"val 003"
"val 011","val 022","val 033"
"val 111","val 222"

Base64 encode

Encodes a string to base64.

{$.inputs.userName} = John Doe

{base64encode: {$.inputs.userName}} = Sm9obiBEb2U=

Base64 decode

Decodes a string from base64.

{$.inputs.userName} = Sm9obiBEb2U=

{base64decode: {$.inputs.userName}} = John Doe