Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content Skip to complementary content

Concatenate fields processor

Merges the content of two fields.

The Concatenate fields processor allows you to merge data that is split between different fields or concatenate the content of a field with a constant string.

Usage

The Concatenate fields processor requires one input flow and can generate only one output flow.

Properties

Properties to configure to concatenate your input fields.

Configuration
Property Configuration
Function name

Concatenate with value/another field: Select this function to merge the content of this field with another field or a custom value, and display it in a new field.

Fields to process

Select the field or fields on which you want to apply a function in the list.

Tip noteIf you want to apply the same function to multiple fields at once, click the Open dialog. Open dialog icon to open a tree view that allows you to select multiple fields.
Create new field Enable this option to create a new field after applying the function. If you do not enable this option, the existing field will be kept and modified.
Rename new field Give a custom name to the newly created field.
Prefix (optional) Add a prefix to the value of the output field.
Use with
  • Field: Select this option to concatenate the field to process with another field from the drop-down list.

  • Value: Select this option to concatenate the field to process with the custom value of your choice, set in the Suffix field.

Separator Type in the separator you want to use when combining the two fields/values. If left empty, no separator will be used.
Add separator
  • Both values are empty: Select this option to add a separator only when both fields/values are not empty.

  • Always: Select this option to add a separator to all combined fields/values.

Suffix (optional) Add a suffix to the value of the output field.

To rename the processor or edit its description, click the Edit Edit icon next to the processor name in the Properties panel.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!