How to update a null

[mohiahmed]

Hello all

I am trying to update few variables using IF, all of them update where there is a value however when there's no value I can't get the query to update the field with a comment.

Can you please help

   LOW_SEG_CDE,
If([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default',
If([LOW_SEG_CDE] = 'null', 'Default_Depository',)))) as 'SRP_Marker', 

[PrashantSangle]

Hi,

use

isnull(FieldName) or len(trim(FieldName))=0,'Default Depositry'

Regards

[sunny_talwar · Accepted solution]

How about try this

If([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default', 'Default_Depository'))) as 'SRP_Marker',

[stigchel]

Or use an applymap

SRP_Marker:

Mapping Load * Inline [From, To

'DD1', 1 Default',
'DD2', '2 Attested',
'DD3', 'BI Default',

];

Load ...

...
ApplyMap('SRP_Marker',LOW_SEG_CDE,'Default_Depository') as 'SRP_Marker',

....

From

[Anonymous]

Hi,

Try below code

f([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default',  'Default_Depository',))) as 'SRP_Marker',

Thanks,

Venkata Sreekanth

[mohiahmed]

Thank you all for your help, it was truly appreciated.