sql query in the column level

[suvbin]

Hi Qlik,

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

Thanks.

[john_wang]

Hello @suvbin ,

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.

[suvbin]

Hi Alan,

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

[john_wang]

Hello @suvbin ,

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

Regares,

John.