Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
muthyarn
Contributor
Contributor

AWS Redshift - Empty Column value store as NULL

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?

 

Labels (1)
4 Replies
narendersarva
Support
Support

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
Contributor
Contributor
Author

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
Support
Support

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
Support
Support

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