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
Solved
Categorizing data based on external table with unique lookup min/max values
+1- Participant
Best answer by gcarmich
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.
+1- Participant
- Best Answer
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.
+11- Contributor
write small python program and call using pythoncaller
2nd approach inline querier(fme transformer)
python program is faster than inlinequerier.
Thanks
Kemminje
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.