Filtering NULL Values in Qlik Replicate

[user2828]

Hi Team,

I want to filter out records as per the below condition:

The cardnumber from source which has null values should not be pushed to target. Only cardnumber which holds field values should be pushed. How can I achieve this.

[DesmondWOO · Accepted solution]

Hi @user2828 ,

Thank you for reaching out to the Qlik Community. Please try the following syntax in the filter.

$CARDNUMBER IS NOT NULL

Regards,
Desmond

[user2828]

Hi @DesmondWOO I tried this but I seems that this is not working, I can still get null records

[Steve_Nguyen]

@user2828 that filter should have works, the UI transferred count show source record count but target should only have records that do not have null

i tested with 

$CARDNUMBER IS NOT NULL

and

$CARDNUMBER>=0

===

assume  $CARDNUMBER is not a text or lobs column type , as LOBs can not be filter.

[user2828]

That should have worked but at the source cardnumber column is of type varchar

[DesmondWOO]

Hi @user2828 ,

What is your source database? 

Regards,
Desmond

[user2828]

Hi, its Oracle 19x.

[Steve_Nguyen · Accepted solution]

@user2828 i tested on Oracle 19 as well ,and the filter did work

'$Email55 IS NOT NULL

*notes: the UI transferred count show source record count but target should only have records that do not have null

in the task log you would see something like :

2025-01-24T06:33:13 [TRANSFORMATION ]I: Filter for Table 'ORAUSER.t11' is '$Email55 IS NOT NULL'

and on the full load :

2025-01-24T06:33:13 [TARGET_LOAD ]I: Load finished for table 'ORAUSER'.'t11' (Id = 1). 5 rows received. 3 rows skipped. Volume transferred 2680.