Skip to main content
Solved

joining data sets without common field

  • February 22, 2018
  • 4 replies
  • 216 views

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.

View original
Did this help you find an answer to your question?

4 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • 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.


Forum|alt.badge.img
  • Author
  • 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
  • Contributor
  • 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+18
  • Contributor
  • February 22, 2018
gio wrote:

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.

 

 


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