|
POST
|
Hello again ... I meant to include this screen shot of what was referring to in the previous discussion regarding changing the delimiter.
... View more
09-14-2017
04:22 PM
|
0
|
1
|
3080
|
|
POST
|
Hi Dan So I am working away, painfully editing all the field names and assigning merge rules. However, I want to change the delimiter parameters for the output file, from the current 'underscore' to just a 'space'...but the delimiter dialogue box seems to be greyed out and I cant not change this. I looked in environment settings and there doesn't seem to be anything. Any ideas of where I could change this rule. thanks Jess
... View more
09-14-2017
04:21 PM
|
0
|
0
|
3080
|
|
POST
|
Hi Dan Thanks I will try both yours and Chris's suggestions and let you know how I get on. Cheers Jess
... View more
09-14-2017
02:29 PM
|
0
|
0
|
3080
|
|
POST
|
Hi Michelle Thanks for clarify. I always find it slightly confusing on where to ask the questions. So thanks for pointing out some of the key tips. Cheers Jess
... View more
09-14-2017
02:27 PM
|
1
|
0
|
3080
|
|
POST
|
Hi Chris Thanks I will try your suggestions thanks. Cheers Jess
... View more
09-14-2017
02:26 PM
|
0
|
0
|
3080
|
|
POST
|
Hell again I have another question regarding merging point data, yet also merging the fields in the attribute table. I have a standard excel table with set field names, which I want to preserve. So I have exported this shapefile to a featuregeodatabase folder, and now I would like to merge several other point layers to this parent layer. I am assuming the merge tool is the best option?? I have tried merge one of the shapefile to this parent one, and the merged results in the attribute table show all the merged data to the right of the parent layer, and the field names have reverted back to the default naming system. So my question is... 1) Is there away to have the data merged so that final layer has all the data combined under the correct field. So for example the Latitude field in the merging layer in filled in to the Latitude field in the parent layer? 2) Is it possible to have the Field names remain when merging. I have looked this up and there seems to be a lot on using SQL, coding etc...but frankly I have no clue about this langue. I don't really want to manually do this in excel and there is a lot of layers that I need to merge and having the ability to merge the way I would like would be great. I have attached the excel tables to show you what I am hoping to accomplish. I have this excel now as a shapefile and a geodatabase. Please ignore the spaces in this table as I have corrected this. I just want to show you what I want the end attribute table to look like, after merging all the various point data shapefiles. Excel file type to merge...now in a shapefile and geodatabase I have read that to merge and keep field names, it is best to export the shapefiles into a geodatabase and then do the merge. However, when I do this it still seem to append the emerging layer to the right of the attribute. Is there no way around this ??? I apologize if this sound silly and if it has be discussed before. If so please point me in the right direction. Thanks Jess
... View more
09-14-2017
12:04 PM
|
0
|
9
|
4891
|
|
POST
|
Hello Xander I managed to bring the excel file into ArcMaps by editing the field names, as per suggested. So thanks for the help. Cheers Jess
... View more
09-14-2017
11:31 AM
|
1
|
0
|
489
|
|
POST
|
Hi Joe Thanks Ill have a look tomorrow. As I off now. Thanks for getting back to me. Cheers Jess
... View more
09-13-2017
04:41 PM
|
0
|
2
|
489
|
|
POST
|
Hello Jayanta Thanks for your reply. I cleaned up the excel table as per suggested in the previous replies. It seems to be working at the moment. My only other query was if there was a way to keep drop down menus from an excel table in ArcGIS attribute table. I will close this discussion now. Thanks for your help. Cheers Jessica
... View more
09-13-2017
12:58 PM
|
0
|
1
|
1010
|
|
POST
|
Hi Joe and #Darren Wiens Also, realize that there are several data validations (drop down menus) in this table, that I need to have in here. I was wondering if there a way around this when bringing the file into Arc? Any ideas? cheers Jess
... View more
09-13-2017
11:34 AM
|
0
|
4
|
1589
|
|
POST
|
Hey Joe I was wondering about that. I will change it for the purpose of this database. I was hoping I didn't have to change much of what they were wanting. Thanks for clarifying. I am also a wee knew to using other peoples data and as this is a big project, I was trying to stay within their requirement with regards to the table. Anyhow, I greatly appreciate your time. Thanks Jess
... View more
09-13-2017
11:23 AM
|
0
|
0
|
1589
|
|
POST
|
Hi again Joe So I checked the table to see if the ..'...was the problem and then checked to make sure the parameters were 'double' and not text. But I still get the error below. I am not too sure what else to try? Jessica One or more layers failed to draw: ValdesSlidesMetrics$ Events: Syntax error (missing operator) in query expression 'Longitude centrepoint >= -133.851656 AND Latitude centrepoint >= 46.634603 AND Longitude centrepoint <= -119.664869 AND Latitude centrepoint <= 56.379586'. ValdesSlidesMetrics$ Events: An invalid SQL statement was used. [`ValdesSlidesMetrics$`]
... View more
09-13-2017
10:33 AM
|
0
|
0
|
1589
|
|
POST
|
HI Joe Thanks, I was wondering about this. The excel table was sent to me from someone and I thought this might be needed. I will remove it and then see if this works. I let you know. Thanks Jessica
... View more
09-13-2017
10:09 AM
|
0
|
0
|
1589
|
|
POST
|
Hi Darren I get this error when bringing in the excel sheet to ArcMap. I will have a closer look at the excel table for spaces etc...and try again. Also notice Joe Borgione comments below. I will change this and see if it work. Thanks for the help. Cheers Jessica
... View more
09-13-2017
10:07 AM
|
0
|
1
|
1589
|
|
POST
|
This is issue. I am trying bring in a excel table with a standard set of attribute (fields) which I will then merge layers to this new excel table. The issue is that I have an example of how the data should be entered, and when I bring in this excel table I keep getting this error message. One or more layers failed to draw: ValdesSlidesMetrics$ Events: Syntax error (missing operator) in query expression 'Longitude centrepoint >= -129.300244 AND Latitude centrepoint >= 49.622159 AND Longitude centrepoint <= -123.957440 AND Latitude centrepoint <= 53.344866'. ValdesSlidesMetrics$ Events: An invalid SQL statement was used. [`ValdesSlidesMetrics$`] So when I go to export the data it will not work. I was wondering I have missed something...as this is a very simply step and I can not see what I've done wrong. Any suggestions would be most helpful. Thanks Jessica
... View more
09-13-2017
09:39 AM
|
0
|
13
|
3098
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-14-2017 11:31 AM | |
| 1 | 09-14-2017 02:27 PM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:25 AM
|