Skip to main content
  • EN

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 

 

 

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

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

Lookup_Table

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

Lookup_Table

Thanks, it worked

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

Reply


Community Stats

30,479
Posts
115,682
Replies
38,163
Members
Terms & ConditionsCookie 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.