Skip to main content
Question

create a lookup table

  • April 8, 2020
  • 2 replies
  • 427 views
bubblebeb
Contributor
Forum|alt.badge.img+6

I want to create a reference table within the workspace so I don't have to import another data source. I feel like I am missing something easy.

 

I want to create a simple table of

RoleRateAdministrator£20Operative£30Manager£40Director£50

 

I can then join my data to it to get the rates.

I would usually write the table in excel then read it in a featuremerger to match the rates in.

I feel there must be a way to do this in FME rather than have to read the external data source. It must be more efficient.

 

Thanks

 

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

redgeographics
Celebrity
Forum|alt.badge.img+62

The AttributeValueMapper is what you're looking for.

FME rocks! \m/
erik_jan
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • April 8, 2020

Another option would be to create an external Lookup table in for example Excel.

Then you can use the DatabaseJoiner transformer to look up the values.

That would allow you to change the Lookup table without having to open the workspace.

I know you were asking for an internal Lookup table and that would be the AttributeValueMapper as @redgeographics mentioned, but I have the experience the external Lookup table is easier to maintain.

Hope this helps.

Community Stats

32,207
Posts
122,305
Replies
39,891
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.