Skip to main content
  • EN

In my workspace, I've three ESRI GeoDB reader Feature Types with WHERE condition. Here values in the WHERE condition are passed from a private/published parameter input values.

Few things to be considered -

  • There are approximately around 100 values to be passed in sequential order from Excel sheet to Parameter values.
  • Workspace has to run completely for every input parameter value

 

Currently I was passing each value manually to the parameter and is time consuming.

Any thoughts on doing this more efficiently and quickly?

 

Thanks in advance!

Hi @fmeuser_gc, sounds that the FeatureReader could be a quick solution.

Read the parameters from the Excel dataset one by one, build WHERE parameter value, and pass it to the WHERE parameter in the FeatureReaer configured with Esri GDB.

Hi @fmeuser_gc, sounds that the FeatureReader could be a quick solution.

Read the parameters from the Excel dataset one by one, build WHERE parameter value, and pass it to the WHERE parameter in the FeatureReaer configured with Esri GDB.

Thanks @takashi. But is it possible to have multiple feature types in FeatureReader with different WHERE condition for each of the FeatureType?

I've tried this FME 2019, but looks like not supported. Is this supported in FME 2020 ?

Hi @fmeuser_gc, sounds that the FeatureReader could be a quick solution.

Read the parameters from the Excel dataset one by one, build WHERE parameter value, and pass it to the WHERE parameter in the FeatureReaer configured with Esri GDB.

No it's not possible, but it's OK if you pass pairs of feature type name and corresponding WHERE clause to the FeatureReader one by one.

Reply


Community Stats

30,117
Posts
114,307
Replies
37,747
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.