New answers tagged joins
This seems to be a bug (see http://hub.qgis.org/issues/9628 - apparently fixed in 2.2.) Possible workaround: I have experienced that when using fields from joined tables (I have tested dbf and csv), the field calculator messes things up when I choose "Create new field". If I change to "Update existing field", things seem to work.
The .dbf of a shapefile has certain limits on the columns names, e.g. number of characters needs to be <11 characters, and that there cannot be spaces in the column names. I'm guessing when you export out to a new shapefile the function finds these errors and attempts to generate a valid column name. Make sure your column names are shapefile friendly ...
Use ArcGIS Spatial Join Tool with these settings: target_features = layer1 join_features = layerABC join_operation = JOIN_ONE_TO_MANY
If i can store your data in Postgres\Postgis or Spatialite, you can do a query like this: SELECT f.*, g.field_1, g.field_2, g.field_3 FROM table_1 AS f JOIN table_abc AS g ON (ST_Intersects(f.geom, g.geom)) Assuming that your tables are called "table_1" and "table_abc", and that the table _abc fields that you are interested in ...
Yes, the Append2 is the best option I have tried, provided you have all the TABs with similar "Table Structure". See the image. Select the check box "To New File" to get the appended/merged final TAB saved to a new file. This option is recommended.
Top 50 recent answers are included