topic Load hardcoded value into target table in Qlik Replicate

Load hardcoded value into target table

desmondchew — Wed, 11 Sep 2024 13:14:36 GMT

Our application team has request to load a table from SQL server as source endpoint into MySQL 8 RDS as target endpoint.

They require hardcoded values in two of the columns in the target table.

Let's say we have a table "vendor" which has column A,B,C,D,E. (Columns A,B,C) shall be replicate as per normal. Meanwhile they want to have a column X and column Y which has hardcoded values as follows

-Column X (1234)

-Column Y('ABC')

How can we do it through replicate?

Re: Load hardcoded value into target table

john_wang — Wed, 11 Sep 2024 14:43:09 GMT

Hello @desmondchew ,

Thanks for reaching out to Qlik Community!

You may use the table level or global level transformation to add 2 columns, and assign them fixed values in the value expression. For example

Thanks,

John.

Re: Load hardcoded value into target table

desmondchew — Thu, 12 Sep 2024 06:55:16 GMT

Thanks John. It worked as expected.

Re: Load hardcoded value into target table

john_wang — Thu, 12 Sep 2024 06:56:45 GMT

Thank you so much for your support! @desmondchew