Skip to main content
Best Answer

using shared parameter with custom transformer for looking for excel files with specific name

  • February 18, 2020
  • 1 reply
  • 35 views
gogopotter90
Contributor
Forum|alt.badge.img+14

Currently ,

i am trying to create user parameter in shared parameter linked with excel file.

 

 

i have an excel file ,it includes id number and names of building ,

 

i want to create user parameter when i write the number ,it wiill read automatic which names that i want to work on from specific excel file ,then it starts scanning or searching for this excel file in specific folder that include the same name and import ths excel file to workspace .

 

Thanks in advance

Best answer by alyssaatsafe

Hi @gogopotter90, I wondered if the FeatureReader transformer would be the one you were looking for. You would be able to specify the Dataset parameter under reader with the value of the name i.e. @Value(name) and it will read this excel file to the workspace. Hope this helps.

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

A
  • alyssaatsafe
  • Best Answer
  • February 22, 2020

Hi @gogopotter90, I wondered if the FeatureReader transformer would be the one you were looking for. You would be able to specify the Dataset parameter under reader with the value of the name i.e. @Value(name) and it will read this excel file to the workspace. Hope this helps.

Community Stats

32,182
Posts
122,179
Replies
39,856
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.