Qlik Replicate: How to remove schema name from the target folder using ADLS connector

[Sonja_Bauernfeind]

In the target (Azure Data Lake Storage), source tables are replicated with the schema.table name format.

To rename the folder name to tablename only, removing schema:

1. Create a new Global transformation (see Starting the Global Transformation Rules wizard)
2. Choose Rename the schema, click Next
   
   
   
   
3. Skip the Transformation Scope by clicking Next
   
   
4. Tick the rename schema to radial (A) and click fx (B) to add the following expression:

   replace($AR_M_SOURCE_SCHEMA,$AR_M_SOURCE_SCHEMA,'')

    
   
   
5. Click Finish and OK
6. Save the task and reload

Environment

• Qlik Replicate