I can see another question about this. However if my understanding is correct. The where clause is not working for me at any level.
I am using the blm national dataset which has a large number of records for all states. I only need to utilize 1-3 states at this time in my workbench. I have attempted a where clause on the reader
, an SQL before read (which seems like the most efficient) and a where clause on the table.
However the sql before will not run at all.
When running the where clause SECDIVID LIKE 'MN% it runs but in the test filter directly after the reader i begin getting unfiltered records. This should not be possible if it has already filtered by the where.
I am not willing to sit through all of the records (it will be at least 4 hrs) to see what happens.
does this work for anybody else?
What am i doing wrong?
I can see the following in the log. but why doesn't it only return these states. It works in Arcdesktop.
GEODATABASE_FILE_1 Reader: Using Enhanced geometry
Using WHERE clause 'SECDIVID<space>LIKE<space><apos>MN%<apos><space>OR<space>SECDIVID<space>LIKE<space><apos>MI%<apos><space>OR<space>SECDIVID<space>LIKE<space><apos>WI%<apos>'
All network information will be ignored. As a result, edges will be treated as polyline features and junctions will be treated as point features
All relationship information will be ignored. As a result, simple relationships will not be read, and attributed relationships will be read as tables
GEODATABASE_FILE reader: Building features into bulk mode features
