topic Re: Filtering NULL Values in Qlik Replicate in Qlik Replicate

Filtering NULL Values in Qlik Replicate

user2828 — Thu, 23 Jan 2025 07:16:14 GMT

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.

Re: Filtering NULL Values in Qlik Replicate

DesmondWOO — Thu, 23 Jan 2025 08:32:17 GMT

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

Re: Filtering NULL Values in Qlik Replicate

user2828 — Thu, 23 Jan 2025 08:46:16 GMT

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

Re: Filtering NULL Values in Qlik Replicate

Steve_Nguyen — Thu, 23 Jan 2025 12:49:18 GMT

@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.

Re: Filtering NULL Values in Qlik Replicate

user2828 — Fri, 24 Jan 2025 03:24:49 GMT

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

Re: Filtering NULL Values in Qlik Replicate

DesmondWOO — Fri, 24 Jan 2025 03:27:31 GMT

Hi @user2828 ,

What is your source database?

Regards,
Desmond

Re: Filtering NULL Values in Qlik Replicate

user2828 — Fri, 24 Jan 2025 05:09:56 GMT

Hi, its Oracle 19x.

Re: Filtering NULL Values in Qlik Replicate

Steve_Nguyen — Fri, 24 Jan 2025 14:35:54 GMT

@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.