Hi,Young, I tried that one too, still won't work
On 2/26/13 5:12 PM, "Young Ng" <[email protected]> wrote: >C = FILTER B BY itemid is null; > >you cant use == or != for null value > >On Feb 26, 2013, at 3:41 PM, Dan Yi <[email protected]> wrote: > >> Hi, >> >> I have data as following : >> >> Timestamp itemid actiontype >> >> "2012-11-01T23:59:59.000+0000" "" "Search" >> "2012-11-01T23:59:59.000+0000" "688531" "ShowItemDetail" >> .. >> >> I want to filter out all the lines that have itemid as empty, >> I tried different approach but none of work: >> >> C = FILTER B BY itemid != ''; >> C = FILTER B BY itemid != null; >> >> >> Anyone knows how to do it? Thanks. >> >> >> >> >> >
