I wonder how I would write a table for a join which I want to perform.
Right now I wrote a
.txt File, tab-seperated. The headerline only contains letters.
Here is the problematic table: http://www.filedropper.com/lookuptable
I am working with the shapes provided here: http://www.eea.europa.eu/data-and-maps/data/clc-2006-vector-data-version
Thats how my file looks like:
ID CLCCode CLCKlasse 1 111 test1 2 112 test2 3 121 test3 4 122 test4 5 123 test5 6 124 test6 ...
Rightclick on the
.shp. I choose my
.txt file and the two needed fields to perform the join (my key and value pair). My key would be numbers in the attribute table of the shapefile which equals the numbers I wrote in my
But, ArcGIS says that there are no matching records.
I also tried it with a
, as a seperator. I can choose in the dialog
join the textfile, but, the field where it should be stays empty/blanc (it basically gets not selected).
Also, there is something I do not understand. When I open my
.csv file in ArcGIS I see the "CLCCODE" column.But, I cannot choose "CLCCODE" in the Join Dialog, although it is a column of the attribute table.