Skip to main content
Solved

Use parameters in DatabaseJoiner

  • November 16, 2017
  • 1 reply
  • 50 views
jneujens
Forum|alt.badge.img

I noticed that I cannot use parameter values inside the DatabaseJoiner. Am I missing something?

 

 

An example:

When fetching a user parameter to use it is an attribute, the DatabaseJoiner joins another attribute from an excel file to my feature (upper part in the screenshot).

When using the user parameter directly to join attributes from an excel, the transformer parameter button shows red and there is not output. The user parameter has its property 'Attribute Assignment' set to 'Default'.

 

 

I found no relevant information on the forum or in the documentation of the DatabaseJoiner. Could anyone come up with a reason? The workaround using a ParameterFetcher solves the problem easily, but I was wondering why it is not possible to use a parameter directly.

 

 

I am using FME 2017.1.0.0 (Build 17539 - WIN64).

 

 

In the zip file you can find my example workspace and data.

Best answer by takashi

Hi @jneujens, I think the type of Feature Attribute parameter should be "Attribute Name", rather than "Choice". Try creating a new user parameter linking to the Feature Attribute column via the menu button within the parameter field.

See also the last row (To create a user parameter from an existing transformer parameter ) of the table in this page: Creating and Modifying User Parameters

1 Attachments
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.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • November 16, 2017

Hi @jneujens, I think the type of Feature Attribute parameter should be "Attribute Name", rather than "Choice". Try creating a new user parameter linking to the Feature Attribute column via the menu button within the parameter field.

See also the last row (To create a user parameter from an existing transformer parameter ) of the table in this page: Creating and Modifying User Parameters

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

Community Stats

32,154
Posts
122,048
Replies
39,812
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.