Skip to main content
Question

Passing multiple input values to Private parameter

  • May 19, 2020
  • 3 replies
  • 23 views
fmeuser_gc
Contributor
Forum|alt.badge.img+9

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!

Yash K
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    3 replies

    takashi
    Celebrity
    • takashiCelebrity
    • May 19, 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.

    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
    fmeuser_gc
    Contributor
    Forum|alt.badge.img+9
    • fmeuser_gcContributor
    • Author
    • Contributor
    • May 20, 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.

    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 ?

    Yash K
    takashi
    Celebrity
    • takashiCelebrity
    • May 21, 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.

    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

    Community Stats

    32,207
    Posts
    122,305
    Replies
    39,891
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.