Solved

joining data sets without common field

  • 22 February 2018
  • 4 replies
  • 30 views

Badge

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

icon

Best answer by erik_jan 22 February 2018, 16:19

View original

4 replies

Userlevel 2
Badge +12

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.

Badge

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

Badge +3

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

catchment areas .

Is faster then having to do a unconditional merge.

Userlevel 2
Badge +12

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.

 

 

Reply