Problem with null values

[#1]

Hi all,

i have some problem to craete null values replace with any text unknown' can you please suggest me

[tresesco]

Load

          If(IsNull(Field), 'Unknown', Field) as Field

[jagan]

Hi Sanjeev,

Check this

SET NULLDISPLAY=<sym>;

Ex:

SET NULLDISPLAY='Unknown';

Regards,

Jagan.

[MK_QSL]

use below in your script...

IF(IsNull(YourFieldName) or LEN(TRIM(Replace(YourFieldName,'-','')))=0, 'Unknown',YourFieldName) as YourFieldName

[ashfaq_haseeb · Accepted solution]

Like this.

Regards

ASHFAQ

[#6]

thanks Ashfaq

[ashfaq_haseeb]

Welcome

[MK_QSL]

Sanjeev,

Happy to know that you got your answer...

Just for my curiosity, what was wrong with tresesco, Jagan or my answer?

[#9]

I understood he gave with example

[MK_QSL]