topic Re: sql query in the column level in Qlik Replicate

sql query in the column level

suvbin — Thu, 12 Jun 2025 00:43:14 GMT

Hi Qlik,

Do we have any provision for writing sql query like transformation in the column level.

Thanks.

Re: sql query in the column level

john_wang — Thu, 12 Jun 2025 00:48:23 GMT

You can add or remove columns at the transformation, table, or global level. Qlik Replicate will automatically generate the SQL statements and execute them on the target database. These SQL statements are auto-generated and cannot be manually modified, or input them manually in the current major versions.

Hope this helps.

John.

Re: sql query in the column level

suvbin — Thu, 12 Jun 2025 01:28:53 GMT

Hi Alan,

Thank you for the reply. But my doubt is , do we have any provision where we can write SQL queries (like select ).

Re: sql query in the column level

john_wang — Thu, 12 Jun 2025 02:24:51 GMT

Hello @suvbin ,

I'm afraid no, except some expressions in Passthrough Filter, and source_lookup() functions.

Regares,

John.