Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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',
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',
Hi,
use
isnull(FieldName) or len(trim(FieldName))=0,'Default Depositry'
Regards
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',
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
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
Thank you all for your help, it was truly appreciated.