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
Best answer by gcarmich
View originalI 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.
+3
write small python program and call using pythoncaller
2nd approach inline querier(fme transformer)
python program is faster than inlinequerier.
Thanks
Kemminje
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.