problem with table

Thu, 22 Oct 2009 00:56:58 GMT

Hi, there's some script:



LogOnOff:
odbc connect to ...;
load date(DDATE_LOGON, 'DD.MM.YYYY hh:mm:ss') as DDATE_LOGON,
 date(DDATE_LOGOFF, 'DD.MM.YYYY hh:mm:ss') as DDATE_LOGOFF,
 SAUTHID as SAUTHID,
 SPROGRAM as SPROGRAM,
 NRN as NRN
 ;
SQL SELECT *
FROM PARUS."UDO_V_LOGONOFF";

TimeStamps:
directory;
load date(DateTime, 'DD.MM.YYYY hh:mm:ss') as DateTimeStamp
from [TimeStamps.csv] (txt, utf8, embedded labels, delimiter is ',', msq, no eof);

left join (LogOnOff) intervalmatch(DateTimeStamp)
 load DDATE_LOGON, DDATE_LOGOFF
 resident LogOnOff;
//in result I've got nulls in some rows, and I try to remove it:
LogOnOffNew:
load * resident LogOnOff where isnull(DateTimeStamp) = 0;

but I can't see "LogOnOffNew" ... why? may be there's more simple way to do this (for example use "where")?

problem with table

Thu, 22 Oct 2009 01:34:01 GMT

I solve the problem with null in "DateTimeStamp":

change


left join (LogOnOff) intervalmatch(DateTimeStamp) ...


inner join (LogOnOff) intervalmatch(DateTimeStamp) ...

but I can't understand what about null in other fields?

If I create TableBox and use "Omit rows where field is null" - all correct, but how do it in script?

topic problem with table in QlikView

problem with table

problem with table