Validating & replacing data in Attribute View by using string function

[Former Member]

Hi,

Please help me how to replace null or junk value with some text/value in Attribute value. I was tried with replace function but getting error due to syntax error.

replace("CAPACITY","?","     "). Here CAPACITY is column name which is populating with "?" junk value. I want to replace with some spaces or default value. Also pls suggest the way I am doing is right or nt.

Appreciate your suggestions.

Regards,

Ian

[Former Member]

Please try:

coalesce("CAPACITY",'AnyValue')

[Former Member]

Hi Ian B,

             You can follow the below steps in SAP HANA STUDIO...

• Windows --> Preferences --> Admin console --> Common --> Representation of Null value (replace "?" with your "defaults"). 

Thanks and Regards,

Vijay kumar Vanamala

Message was edited by: vijay kumar vanamala