Load hardcoded value into target table

[desmondchew]

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?

[john_wang · Accepted solution]

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.

[desmondchew]

Thanks John. It worked as expected.

[john_wang]

Thank you so much for your support! @desmondchew