Skip to main content
  • EN

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.

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


Community Stats

30,113
Posts
114,305
Replies
37,743
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.