Skip to main content
Solved

Choosing parameter value from a list stored in an Excel field,

  • October 7, 2014
  • 2 replies
  • 6 views
jamal
Forum|alt.badge.img+5
Choosing parameter value from a list stored in an Excel field,

 

 

I couldn’t figure out how the a parameter value can be selected from a list saved in an Excel table

 

 

For example, in the screenshot below, I wanted to choose the “PlanType” value from the shown Excel table

 

 

 

 

 

How this might be accomplished?

 

 

 

Thank you

 

 

Best

 

 

Jamal

Best answer by takashi

Hi Jamal,

 

 

If you choose "Choice" as the parameter type, you can import the Excel list to its choices. Note that the configuration is static. After you once imported, the configuration will not be changed even if you change the original Excel list. You should import again or edit directly, if necessary.

 

 

Takashi
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.

2 replies

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • October 7, 2014
Hi Jamal,

 

 

If you choose "Choice" as the parameter type, you can import the Excel list to its choices. Note that the configuration is static. After you once imported, the configuration will not be changed even if you change the original Excel list. You should import again or edit directly, if necessary.

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
jamal
Forum|alt.badge.img+5
  • jamal
  • Author
  • October 7, 2014
Perfect. Many thanks Takashi for the help.

 

 

I would prefer it to be dynamic such that if any change occur in the excel, it will be reflected on the list.

 

 

However, it is great now. I can live with it

 

 

Best

 

 

Jamal

 

 

Community Stats

32,120
Posts
121,954
Replies
39,772
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.