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
- 35 replies
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+1- Participant
- 35 replies
- 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
- 189 replies
write small python program and call using pythoncaller
2nd approach inline querier(fme transformer)
python program is faster than inlinequerier.
Thanks
Kemminje