AWS Redshift - Empty Column value store as NULL

[muthyarn]

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?

[narendersarva]

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 

[muthyarn]

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 ?

[sureshkumar]

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 

OR

ifnull($ColumnName,' ')

Regards,

Suresh

[SushilKumar]

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