Skip to main content
  • EN

Hi I have used SQLCreator to query multiple tables in SDE using various criteria and end up with a list of IDs.

I would now like to pass the list of IDs to a FeatureReader, so that I can reduce the number of records to read.

Any idea how I can build the whereclause to pass to the featurereader? I would like to build single sql as

ID=any(1,2,3,4...2000)

A combination of ListConcatenator and AttributeCreator should do the trick.

 

 

the AttributeCreator would have something along the lines of ID=any(@Value(_concatenated)).

 

 

Reply


Community Stats

30,179
Posts
114,557
Replies
37,844
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.