Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
When i am writing the Or after IsNull(DD_TYPE) then it is fetching the rows....but when i am writing "and" after IsNull(DD_TYPE) nothing is getting fetched ....i dont know what happming exactly .....is i am doing wrong please suggest me right answer....
Below is my code ...i want all the null records in my report ....
IsNull(DD_TYPE) and
WildMatch(DD_TYPE,'EN','NB','RW','RO','UC')
Please reply its urgent ......
Sarfaraz
my requirement is how i can recognise the null records in table ....
Sarfaraz
Create a couple of Debug fields that will help you understand your data, e.g.
IsNull(DD_TYPE) as DebugField1,
Len(Trim(DD_TYPE)) as DebugField2,
and use the following where clause:
Len(Trim(DD_TYPE))=0 or WildMatch(DD_TYPE,'EN','NB','RW','RO','UC')
The "Len(Trim(DD_TYPE))=0" may be a better condition than IsNull(), since you could have records that are empty but still not NULL.
HIC
Hi,
At the script level,create one field in the table that satisfies your condition ,take a look at the following example:
*************************************************************************
data:
LOAD name,
DD_TYPE
FROM
data.xls
(biff, embedded labels, table is Sheet1$);
data1:
load name,DD_TYPE,
if(IsNull(DD_TYPE) or WildMatch(DD_TYPE,'EN','NB','RW','RO','UC'),1,0) as test
resident data;
drop table data;
************************************************************************
then in the front end ,create one chart having following expression
only({<test={1}>}name)
You will get what you are looking for but make sure field 'name' must not contain any null values .
Hope this will help you.
Thanks and Regards,
Geeta