Skip to main content
Solved

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

  • Dec 18, 2023 10:28 PM UTC
  • 4 replies
  • 85 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

View original
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+22
  • joepkInfluencer
  • Influencer
  • Dec 19, 2023 7:40 AM UTC

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+69
  • geomancerEvangelist
  • Evangelist
  • Best Answer
  • Dec 19, 2023 10:54 AM UTC

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

Lookup_Table

Just try it!
osasfrer
Contributor
Forum|alt.badge.img
  • osasfrerContributor
  • Author
  • Contributor
  • Dec 21, 2023 4:54 PM UTC

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
  • Dec 21, 2023 4:58 PM UTC

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,994
Posts
125,047
Replies
41,922
Members
Terms & ConditionsAccessibility 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.