topic AWS Redshift - Empty Column value store as NULL in Qlik Replicate

AWS Redshift - Empty Column value store as NULL

muthyarn — Thu, 18 Jul 2024 21:20:08 GMT

We are using SAP as the source and AWS Redshift as the target for QLIK Replicate. Currently, columns with no value are being populated as empty/blank values. Is there a way to configure it to load as NULL instead? In the COPY statement, we have the "EMPTYASNULL" option, which should handle this, but how can I change this in the QLIK Replicate configuration?

Re: AWS Redshift - Empty Column value store as NULL

narendersarva — Thu, 18 Jul 2024 21:34:31 GMT

Hi @muthyarn

Which replicate version you are on? Also did it work before for any other tasks? Please ensure the replicate version you are using supports EMPTYASNULL

Thanks
Naren

Re: AWS Redshift - Empty Column value store as NULL

muthyarn — Thu, 18 Jul 2024 22:03:31 GMT

We are using Replicate May 2023 SR01. No, it did not work for any Task. Is the new version of QLIK replicate supports "EMPTYASNULL" for AWS redshift target ?

Re: AWS Redshift - Empty Column value store as NULL

sureshkumar — Mon, 22 Jul 2024 09:29:38 GMT

Hello @muthyarn

Check below transformation whether it works for you or not.

Double click on the table-->Transform-->Apply expression (fx) for the column you want to apply.

CASE $ColumnName WHEN null Then ' ' Else $ColumnName END

ifnull($ColumnName,' ')

Regards,

Suresh

Re: AWS Redshift - Empty Column value store as NULL

SushilKumar — Tue, 23 Jul 2024 08:15:35 GMT

Hello @muthyarn

To add more to previous TSE comments. Check the data type under the Endpoint in the Qlik help document . Sometime Storing the data and allocate block on storage depend upon the endpoint as well. for e.g. Oracle consider Spaces a Value however other endpoint does not.

Regards,

Sushil Kumar