Skip to main content
Solved

How can I perform a two dimensional lookup from an external excel sheet?

  • December 18, 2023
  • 4 replies
  • 32 views
osasfrer
Contributor
Forum|alt.badge.img

For example:

 

I have an external table that has regions for column headings (North, South, East, West) and part numbers for row headings (Part#001, Part#002, Part#003, Part #004,...). A part number in a specific region has a cost as shown in the in the image.

 

Also, I have another table with the attributes Region and Part Number in FME.

 

I want to make a new attribute that searches the external table based on the two attributes in my FME table: region and part number and returns the cost. How can I do this?

 

Annotation 2023-12-18 152500 

 

 

Best answer by geomancer

This can be done with just a FeatureJoiner and an AttributeDereferencer.

Lookup_Table

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.

4 replies

joepk
Influencer
Forum|alt.badge.img+20
  • joepkInfluencer
  • Influencer
  • December 19, 2023

Hi,

If you make sure your regions are seen as attributes (by e.g. setting row 2 as header in your Reader settings). You can use a Tester for the part numbers and maybe an AttributeKeeper for the regions? The Tester will return one feature/record and the AttributeKeeper will remove all regions you are not interested in.

Hope this helps

geomancer
Evangelist
Forum|alt.badge.img+60
  • geomancerEvangelist
  • Evangelist
  • Best Answer
  • December 19, 2023

This can be done with just a FeatureJoiner and an AttributeDereferencer.

Lookup_Table

osasfrer
Contributor
Forum|alt.badge.img
  • osasfrerContributor
  • Author
  • Contributor
  • December 21, 2023

This can be done with just a FeatureJoiner and an AttributeDereferencer.

Lookup_Table

Thanks, it worked

osasfrer
Contributor
Forum|alt.badge.img
  • osasfrerContributor
  • Author
  • Contributor
  • December 21, 2023

Hi,

If you make sure your regions are seen as attributes (by e.g. setting row 2 as header in your Reader settings). You can use a Tester for the part numbers and maybe an AttributeKeeper for the regions? The Tester will return one feature/record and the AttributeKeeper will remove all regions you are not interested in.

Hope this helps

I want all the records to be displayed all at once in a table

Community Stats

32,154
Posts
122,047
Replies
39,812
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.