Hi guys,
im using a csv file (with sde feature class names and etc.) as initiator to read various feature classes from a Esri sde database.
however i also need to setup a spatial filter on this feature reader to limit the number of record being read.
is there a way I can get this setup? I tried add another initiator into same feature reader transformer but seems this is not working..
Thanks guys!
Hi there! If you're using the Spatial Filter option in the FeatureReader, it expects an initiator feature (or multiple features) with a geometry. If I look at your provided image, it looks like you're reading both boundaries and a csv as input for your FeatureReader. I'm assuming the CSV file features might not have the geometry, but are needed to provide the where clause, or other parameters for the FeatureReader.
If possible, you could try and join the CSV with the other FeatureType(EDITOR.TEST..) on your canvas and then use that as an initiator feature. That way, the feature has both the geometry and the attributes for the where clause.
I made a lot of assumptions in my answer, feel free to provide some more details if everything I assumed is wrong :)
Hope this helps!
Pim
All assumptions you made was correct pim ^.^
and yep by joining the csv with boundary perfectly solved the issue. it couldn't run through I think cos all the where clause I had in there!
Thanks a lot!