Passing a flag column from qlik task

[user2828]

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?

[SachinB]

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

[user2828]

Hi Sachin,

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

[sureshkumar]

Hello @user2828 

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

Regards,
Suresh

[SachinB]

Hello @user2828 ,

It appears to be double quote.

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

Try above and update us.

Regards,

Sachin B

[Laurin37]

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

[DesmondWOO · Accepted solution]

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

[user2828]

Thankyou @DesmondWOO this has solved my query