topic Re: empty string to null in Qlik Replicate

empty string to null

anvitha — Wed, 21 Jul 2021 07:28:43 GMT

Null value in oracle gets converted to empty string(which is treated as null in oracle though) in postgres when used with source_lookup function.

without source_lookup function, null is migrated as null.

Since there isn't testing calls for source_lookup, would want suggestions on how do I check the result of it which might probably be to check the target table. If so, how do I ensure null is converted as null even with source_lookup?

Re: empty string to null

john_wang — Mon, 23 Aug 2021 02:57:23 GMT

Hello @anvitha ,

I tried to validate the NULL value by adding nullif() function however it does not help while use source_lookup (it does work while without source_lookup), my expression looks like:

nullif(source_lookup('NO_CACHING','SCHEMANAME','TBLNAME','COLNAME','PKCOL=:1',$PKCOL),NULL)

I'd like to suggest you open a support case and check further if you need the feature.

Regards,

John.