How to use the Qlik Replicate Expression builder

[avidary_qlik]

The Qlik Replicate Expression Builder provides an easy way to build an expression. It provides you with easy access to the required elements for your expression without having to type out any information manually. You access the Expression Builder through the dialog boxes where you define Filters, Defining transformations for a single table/view, and Global Transformations when you do any of the following:

• Rename Schema
• Rename Table
• Rename Column

To use the Expression Builder:

1. To navigate to the expression builder screen, open the task in Designer mode (1)
2. From the  selected table grid double-click the table name (2)
   
   
   
   
3. This opens the Table Settings - [Table Name] window
4. Select the Transform tab, which will list the task's tables.
   
   For this tutorial, we will create a new column for the company address E.G company name + address.
   
   
5. Click Add Column.
   
   
   
   
6.  This opens the Expression Builder 
   
   
   
7. To create an expression that will combine the COMPANY and ADDRESS:
   1. In the Input Columns tab add the COMPANY name column to the Build Expression box.
   2. Click the concatenate (||) operator from the Operator bar at the top of the Build Expression box.
   3. In the Input Columns tab add the ADDRESS column to the Build Expression box.
   4. Your screen should look like that: “$CompanyName||$Address
   5. Click [Parse Expression]
   6. Add new values
   7. Click [Test Expression]
   8. Verify that the results are the excepted
   9. Click [OK]
   10. Verify the newly added column.
       
       
       
       
   11. Run the task and check that the newly created files apres on the target system

Related Content:

Using the Expression Builder