$where will not filter dataset where col values are zero
16 views
Skip to first unread message
Cold Gin
unread,
May 28, 2016, 5:29:07 AM5/28/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Incanter
Hello. I have two rows in my dataset where the column value (mycol) is 0 when I do (i/view dataset). I have tried all of the following $where variations to retrieve the zero rows, but none of these $where queries will return them:
(i/$ 11 (i/$where {:11 {:eq 0.0}} dataset))
(i/$where {:11 {:eq 0.0}} dataset)
(i/$where {:mycol {:eq 0.0}} dataset)
(i/$where {:mycol {:eq 0}} dataset)
(i/$where {:11 {:$fn #(= % 0)}} dataset)
(i/$where {:11 {:$fn #(nil? % )}} dataset)
(i/$where {:mycol {:eq ""}} dataset)
(i/$where {:mycol {:eq " "}} dataset)
(i/$where {:11 {:$eq 0.0}} dataset)
(i/$where {:11 {:$eq 0}} dataset)
Any insights on how I can filter and bring back only the zero rows? The $where clause does work if I explicitly select by another different column string value in the same row. I need to detect the rows that have zero for the mycol column though.