Skip to main content
Question

How to use a main dataset and a lookup dataset to create new columns without using an attribute filter?

  • September 27, 2023
  • 1 reply
  • 12 views
emerson_styles
Contributor
Forum|alt.badge.img+2

I have two data sets - one is a 'main' dataset and the other is a 'lookup' dataset containing further information. In my main dataset I have a columns called 'Visibility' and 'road_condition' that contain a range of values from 1-13. There are over 4000 rows in the dataset. In my lookup dataset, I have 'code' and 'Column' columns that contain further information relating to each record in the main dataset. See screenshots of the data below.

 

Is there a way to create new columns in the main dataset called 'Visibility_Info' and 'Road_Condition_Info' that merges the data from the main and lookup datasets together without filtering each of the values in the 'Column' column individually before passing the data through to a FeatureMerger?

3 Attachments

1 reply

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • September 27, 2023

You should be able to replace the codes with the additional information with the SchemaMapper, then rename those to add the _Info suffix and then merge back to your original data

imageSo if your original data looks like this

imageAnd your lookup data looks like this

imageYou should end up with this

image

Reply


Helpful Members This Week

Community Stats

31,344
Posts
118,876
Replies
38,937
Members

Latest FME

Terms & ConditionsCookie settings

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.