I have a feature class of ~1000 polygons and 10 tables with time-related information on those polygons (each ~3000 lines). So, I want 10 output feature classes. I used Make Query Table and tried to relate entries via expression field. That always results in an error though (see images below for detail). So, I skipped that and made a selection on the related field in the query table itself and exported to a feature class. That has a bizarre result: The dialog says it exports "from 3264 entries" but it still calculates millions of lines, just as if I had made no selection at all. Thus, the export takes hours - and I have to do it frequently.
So, my question is how to avoid the errors I get in Make query table when using SQL expression.
أكثر...
So, my question is how to avoid the errors I get in Make query table when using SQL expression.
أكثر...