Skip to main content

Qlik Replicate: Creating expressions for columns containing special character '$'

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Alan_Wang
Support
Support

Qlik Replicate: Creating expressions for columns containing special character '$'

Last Update:

Dec 6, 2023 5:27:21 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 6, 2023 5:25:52 AM

The syntax used for creating expressions on column names that contain the symbol '$' differs between Qlik Replicate versions. This article documents the two different methods.

The syntax changed with the May 2023 release. Previously, the syntax allowed the full column name to be recognized with a '$' symbol in front of the column name. With the current syntax, Qlik Replicate interprets these expressions as containing two separate columns and will error out. 

Content:

 

Qlik Replicate May 2023 and later

Starting with the May 2023 release, extra '$' symbols are treated as an additional column name. To correctly format the expression to read it as a single column, the setting Support special characters in column names used in expressions must be enabled and the syntax of double quoting the column name should be used.

Enable the transformation setting:

  1. Open your Endpoint's Task settings
  2. Go to Task settings
  3. Go to Transformations and Filters 
  4. Open Expression Defaults
  5. Check Support special characters in column names used in expressions

    support special characters in column names used in expressions.png

 

Syntax example:

Column name: IXF$RP
Expression: "IXF$RP"

expression builder example may 2023 and later releases.png

If support for special characters is not toggled on, the Parse expression will not parse.

support special characters in column names not toggled on.png

If the extra '$' is used, the expression will treat the column name as two separate columns. Running the expression as is will lead to the task failing with "Failed to init column calculation expression".

quotes not used.png

 

Qlik Replicate versions prior to May 2023

Previous syntax example:

Column name: IXF$RP
Expression: $IXF$RP

expression builder example pre may 2023 releases.png

 

Related Content

Transformations and Filters 

The warning and example provided in the user guide refer to string literals used in an expression and not the column name. Single quotes should be used for the string literals and not the column name.

 

Environment

Qlik Replicate

Labels (1)
Version history
Last update:
‎2023-12-06 05:27 AM
Updated by: