Skip to main content
  • EN

I have two tables. One with input data the other with unique high/low lookup ranges to categorize the input data. The lookup ranges and input data are numeric values. How can I append the associated data in the lookup ranges table to the input data based on where it falls between the min/max values? I considered AttributeRangeMapper but that will not allow comparison between two tables. Thank you, Gil

I found an answer on the FME Knowledge Base.

https://community.safe.com/s/question/0D54Q000080hTQTSA2/merging-2-csv-files-based-on-a-number-range

This approach joins the two tables the uses TestFilter to identify which values fall into the range.

Worked as needed.

write small python program and call using pythoncaller

2nd approach inline querier(fme transformer)

 

python program is faster than inlinequerier.

 

Thanks

Kemminje

 

Reply


Community Stats

30,126
Posts
114,364
Replies
37,763
Members
Terms & ConditionsCookie 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.