Skip to main content
Question

How to create FME workbench so it reads excel Formula? it needs to read columns with no formulas and give the values in that column and then also columns with formulas and give back those formulas

G

3 replies

G
  • grishmash
  • Author
  • May 31, 2017
P.S. Get FME to read those formula directly from the excel sheet and give the output back

 

 

david_r
Celebrity
  • david_rCelebrity
  • June 1, 2017

When creating the reader, click Options and make sure "Read formulas" is checked. It will then create an extra attribute with the suffix ".formula".

Example: your Excel sheet has a column "my_value", FME will then create the attribute "my_value" and my_value.formula" on the reader:

takashi
Evangelist
  • takashiEvangelist
  • June 2, 2017
for example?

 

 

Reply


Helpful Members This Week

Community Stats

31,476
Posts
119,326
Replies
39,090
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.