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

user2828 — Thu, 13 Feb 2025 12:08:51 GMT

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:

mesgoutput1column
- Extract from the mesg column using:
  
  SUBSTRING(mesg, 290, 4)
- Store this in a new column called mesgoutput1column.
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

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

john_wang — Fri, 14 Feb 2025 03:35:55 GMT

Hello @user2828 ,

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.

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

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

Use Cases:

Question:

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