Filtering Data and Creating New Columns in Qlik Replicate Based on Substring Condition

[Sreehari]

Hi Qlik Community,

I have a requirement in Qlik Replicate where I need to extract specific substrings from a column (mesg) in my source table (table_1) and create two new columns based on these conditions.

Use Cases:

1. mesgoutput1column

   • Extract  from the mesg column using:
     SUBSTRING(mesg, 290, 4)
   • Store this in a new column called mesgoutput1column.

2. mesgoutput2column

   • Extract from the mesg column using:
     SUBSTRING(mesg, 194, 6)
   • Store this in a new column called mesgoutput2column.

Question:

• Can I apply these transformations directly in Replicate within the replication task?
• If yes, how can I create 2 computed columns to extract these substring values?
  
  

Thanks,

Sreehari

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[john_wang · Accepted solution]

Hello @Sreehari ,

Qlik Replicate provides rich built-in transformations to support various functions for different purpose.

For your sample, you may define 2 new columns as below:

The column mesgoutput1column expression is as below:

Where the computed column mesgoutput1column retrieves substring from column NAME of the source table.

Hope this helps.

John.