Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts
I have a listbox which shows all the values that are in my table exept for empty field. Is it possible to show the empty fields in the listbox, too? I would like to select the datasets that contain no values in this table through the listbox...
Thank you for your help!
Hi Jan,
You have to write the script outside of the load statement,
NullAsValue Jobkriterium;
Set NullValue='NA';
load *;
SQL SELECT bez as Jobkriterium,
beznr as Jobkritnr,
bezart
FROM EASY.divbez where bezart = 9;
Cool! This one works, exept that it does not give me "NA" values.
Hi Allesandro
Thank your for your help.
I am not sure if I enter the code at the right lace since it duplicates my values in the listbox. Do I enter it under the header 'formula'?
Best
Jan
It means, specified field doesn't have NULL value. Attachment for your reference.
Ok. If I read the fields that are empty into a table it shows '-' what else could be in these fields? 0?
Sorry for keeping you busy on this...
In general tab of the listbox, in the "Field" at the bottom you find expression. Do not use the tab expression otherways as you said you have duplicated values
If it is NULL, it will show '-' in tablebox. If you are using field in expression, for example Sales field has some null entry and if you use Sum(Sales) than it will give you 0.
Hi,
you need to assign the value for null to select them
just use
NullAsValue *;
SET NullValue ="NA";
tablename:
Load
....
...
;
Hi,
Use Nullasvalue concept and you will get the required output in the listbox
HTH
Ravi N.