The source table defined in a Qlik Replicate Task has space in the table name but the target endpoint does not allow space in the Table Name. This article documents how you can rename the target table using a transformation in Qlik Replicate.
Environment
Qlik Replicate
Renaming a table in Qlik Replicate requires the creation of a Global Rule using transformation and rename table options.
- Open the Task in Designer Mode and click on Global Rule and Transformation
- Select Rename Table
- Click Next until you arrive at the Rename Table and Expression screen
- Click on the fx (expression)
- The expression builder will show:
- Test the Expression before saving the Global Rule
More information on Expressions within Replicate can be found in Using the Expression Builder