+4
I have Table1 with the attributes "code start" and "code end".
Table2 contains a code and geometry.
Now I need the geometries conmbined from al codes that are between "code start" and "code end".
Examples:
Id 1 will get only the gemoetry of code 6371 AB
id 3 will get the geometries of code 6371 AP and 6371 AR combined
Id 5 will get the geometries combined of all codes between 6371 BA and 6371 BD
Best answer by geomancer
View original
+30
+4
Hi Danilo,
Table1 is just an example, the real table contains 235.000 records.
Table2 contains 31.000 records,.
The AttributeRangeMapper is not really an option in this case I guess.
+36
Use an InlineQuerier to add the ID's (and the Start and End Codes) from Table 1 to Table 2, then dissolve the geometries from Table 1 on ID.
+17
Hi @raimond , here is another approach with no coding.
+4
Hi @raimond , here is another approach with no coding.
Unfortunaly we use FME 2020, si I can't use this solution.
Maybe if we upgrade later.
Thanks anyway.
+4
Use an InlineQuerier to add the ID's (and the Start and End Codes) from Table 1 to Table 2, then dissolve the geometries from Table 1 on ID.
Thank you, the InlineQuerier works great.
This is what I was looking for.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
