+4I 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
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.
+51+4Hi 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.
+58Use 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.
+4Hi @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.
+4Use 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.
