Skip to main content
Solved

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

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
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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
Influencer
  • takashiInfluencer
  • 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
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

 

 

Helpful Members This Week

Community Stats

31,319
Posts
118,814
Replies
38,946
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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