Timeline for Select_analysis in ArcPy gives ERROR 000358?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 23, 2018 at 8:22 | comment | added | user130347 |
I mean what you did there but also choose what columns from test1 to exist at the output.
|
|
| Oct 23, 2018 at 7:59 | comment | added | JuniorPythonNewbie | You want to extract selection? If yes --> then use Copy Features. | |
| Oct 23, 2018 at 7:37 | comment | added | user130347 | If I want to keep certain columns at the end how can I do it? | |
| Oct 23, 2018 at 6:12 | vote | accept | user130347 | ||
| Oct 23, 2018 at 6:00 | comment | added | user130347 | it's a geodatabse in ArcMap. Is there a way to use a normal select statement as we would in a database? Or it has to be typed like in the answer? | |
| Oct 22, 2018 at 15:20 | comment | added | SMiller |
Is this a column as an attribute in a shapefile or featureclass, or in a CSV table, or some other data source? When you read the input, you should be able to break it up using split in arcpy, for example whereclause = sqlquery.split("WHERE ")[-1]
|
|
| Oct 22, 2018 at 14:31 | comment | added | user130347 | To explain, the select query I have in the question is an alternative way to do what you did.The thing is that the queries have the first form (select ... from .. where). How can I make it process queries in that form, just like in a database?using Select_analysis? Thanks | |
| Oct 22, 2018 at 14:27 | comment | added | JuniorPythonNewbie | Just add some more info about your problem, ex. some screenshots of that table. | |
| Oct 22, 2018 at 14:23 | comment | added | user130347 | I know this works the problem is that I have a column full of select statements and I will need to use them as full sql queries like in a database. Can you tell me how to make it work with the query above?I am upvoting for the effort though | |
| Oct 22, 2018 at 14:17 | history | answered | JuniorPythonNewbie | CC BY-SA 4.0 |