topic Re: Passing a flag column from qlik task in Qlik Replicate

Passing a flag column from qlik task

user2828 — Mon, 30 Sep 2024 06:23:56 GMT

Hi team,

I have a flag column at target which I have set the default value as '0'. While replicating from source can I add this flag column in Qlik task in Table setting>Transform. So that it will be available at target?

Re: Passing a flag column from qlik task

SachinB — Mon, 30 Sep 2024 10:06:30 GMT

Hello @user2828 ,

Thank you for reaching out to the Qlik community!

You can add this extra column at replicate end in order to reflect at target endpoint. Below is the screen shot for the same.

And in function tab you can use the below formula in order to hard code the value if nothing is coming out from source.

Hope this helps for you.

Regards,

Sachin B

Re: Passing a flag column from qlik task

user2828 — Mon, 30 Sep 2024 12:35:35 GMT

Hi Sachin,

While trying to achieve what you have shared, I got the following error message.
Error

Re: Passing a flag column from qlik task

sureshkumar — Mon, 30 Sep 2024 12:52:46 GMT

Hello @user2828

Please try with single = instead of Double equals in transformation and let us know the result.

Regards,
Suresh

Re: Passing a flag column from qlik task

SachinB — Mon, 30 Sep 2024 13:53:47 GMT

Hello @user2828 ,

It appears to be double quote.

CASE WHEN $DESCRIPTION==' ' THEN 'null'
ELSE $DESCRIPTION
END

Try above and update us.

Regards,

Sachin B

Re: Passing a flag column from qlik task

Laurin37 — Tue, 01 Oct 2024 05:45:27 GMT

Hey @user2828,
I guess u have to use a double quote and not an quotation mark in the statement:

Use this:
CASE WHEN $flag == ' ' THEN 'null'

And not this:
CASE WHEN $flag == " THEN 'null'

Best regards,
Laurin

Re: Passing a flag column from qlik task

DesmondWOO — Fri, 04 Oct 2024 06:14:17 GMT

Hi @user2828 ,

I don't believe it's an issue related to single or double quotes. The error occurs because your source table does not have a "flag" column. For your request, you simply need to set your expression to 0. For example

Regards,
Desmond

Re: Passing a flag column from qlik task

user2828 — Fri, 04 Oct 2024 07:33:46 GMT

Thankyou @DesmondWOO this has solved my query