Skip to main content
Solved

joining data sets without common field

  • February 22, 2018
  • 4 replies
  • 261 views
I
Forum|alt.badge.img

Hi everyone,

I have two data sets

  • One contains many catchment areas and their sizes (calculated)
  • The second has the total area of all catchments (Calculated)

I need to join these two so that I can then use an ExpressionEvaluator on them to determine percentages. How do I do this if they do not have a common attribute to join on? I tried a FeatureMerger assigning them both a value of 1 as I thought I read somewhere that that would work... but can not find that article again :-(

Thanks!

Iris

Best answer by erik_jan

Yes, if you assign the requestor and supplier join fields the value 1, you will create an unconditional join (joining in your case the second record with the total area on all first records).

Make sure the multi records is requestor and the one the supplier.

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

erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • Best Answer
  • February 22, 2018

Yes, if you assign the requestor and supplier join fields the value 1, you will create an unconditional join (joining in your case the second record with the total area on all first records).

Make sure the multi records is requestor and the one the supplier.

I
Forum|alt.badge.img
  • irisvb
  • Author
  • 4 replies
  • February 22, 2018

So I was half way there… I had them reversed, I ran it again with the correction and it worked as it should. I guess it was a PEBCAK (Problem Exists Between Chair And Keyboard)

Thanks for the help and quick response!

Iris

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • 2252 replies
  • February 22, 2018

also a variable setter on the total area and variable retriever on the

catchment areas .

Is faster then having to do a unconditional merge.

erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • February 22, 2018

also a variable setter on the total area and variable retriever on the

catchment areas .

Is faster then having to do a unconditional merge.

Only works if you can be sure the total is read before the other data.

 

 

Community Stats

32,087
Posts
121,856
Replies
39,729
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.