topic Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues. in Ocean Science Questions

Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 16:36:42 GMT

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

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JayantaPoddar — Wed, 13 Sep 2017 19:14:00 GMT

What software are you using? If using ArcMap, did you try How To: Import XY data tables to ArcMap and convert the data to a shapefile ?

Ensure there are no invalid variables in Lon./Lat. fields. Could you also attach a sample excel sheet which is troubling you?

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

RebeccaStrauch__GISP — Wed, 13 Sep 2017 19:27:18 GMT

Duplicate of Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I a…

JMRutherford there is no need to duplicate posts and many times can confuse the issue since you will have users answering in multiple threads. instead, you can easily tag other spaces/groups with the @ and the space/group name. One you hit the @ and type a letter, you should get a list of possibly groups.

This post may help in the future https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-to-ask-questions-and-get-answers?sr=search&searchId=46360ed0-d78e-4577-8db4-9b089959c3bf&searchIndex=4‌

Also, make sure to close out thread after marking helpful posts and the correct answer, or "assumed answered" if none, but ready to close, This helps others find the post. thanks.

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 19:58:56 GMT

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

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JayantaPoddar — Wed, 13 Sep 2017 20:05:36 GMT

I am afraid that won't be possible. You could use Definition Query to filter values in a Layer (used to display subset of features in a layer), but would be a Layer-level filtering, not field-level.