How to combine the values from two datasets based on range comparison?

Hi,

You may have solved this already, but I will attach a potential workflow for any future users who come across this.

I would suggest:

• Joining all the feature ranges from Dataset B onto Dataset A using a FeatureMerger
  • Set Process Duplicate Suppliers = Yes
  • Set Generate list = Yes
  • Set List Name = 'attribute_list'
  • Set Add to List = All Attributes
• Exploding the list of relationships using ListExploder
  • List Attribute = attribute_list{}
• Testing the resulting relationships 'ref_length' >= 'start_length' AND 'ref_length' < 'end_length'
  • You could use In Range instead

It's not the most efficient process, because the number of relationships will equal (Dataset A count)*(Dataset B count) which can get large quickly.

------------------------------------------------------------------------------------------------------------------------------------------

Alternatively, you could use an InlineQuerier with a custom SQL statement with the following configuration:

where the SQL Query is

SELECT Dataset_A.*, Dataset_B.*

FROM Dataset_A CROSS JOIN Dataset_B

WHERE Dataset_A.ref_length >= Dataset_B.start_length AND Dataset_A.ref_length < Dataset_B.end_length;