Skip to main content
Solved

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

  • February 18, 2020
  • 1 reply
  • 11 views

gogopotter90
Contributor
Forum|alt.badge.img+13

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.

View original
Did this help you find an answer to your question?

1 reply

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


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