Skip to main content
Question

How to implement a range value expression as key in feature merger

  • July 19, 2023
  • 1 reply
  • 8 views
keller
Contributor
Forum|alt.badge.img+7

This might be an easy one but i could not find a way around it, I have two files File A (lines with geometry) and File B CSV file(lines without geometry). Both files have ID,START,END columns as shown below. So i was wondering how can i merge them on ID as the first key and also specify the range of the start value as the second key, (any other approach is welcomed)imageso what i expect is the first two values of FileB be given geometry from the first value of file A, and the third value of FileB be given geometry from the second value from FileA.

Thanks ,

Keller.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • July 19, 2023

You should be able to use the InlineQuerier for this, something like 

SELECT B.*, A.A_ID FROM
FileA A,
FileB B
WHERE A.ID = B.ID
AND B.START >= A.START
AND B.END <= A.END

 

Reply


Helpful Members This Week

Community Stats

31,341
Posts
118,857
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.