Ok, I'm having issues with what seems like a simple task. I 'm trying to select the latest record from multiple facilities in a Table. For example... the latest inspection record for City electrical transformers. Ive tried the Sort Tool and Summarize tool - both are not working within the Model I'm building. I was excited to see the expression for the select by attributes tool below. If anyone knows how to get this expression to work in Arc10, I would really be interested to hear how! Ultimately I'll create a Feature Class Layer from the selection.
[mydate] in (SELECT max( [mydate] ) FROM table_name GROUP BY [groupID])
I have posted an idea to improve the ability to find Min and Max Dates and perform subqueries in fgdb's here. Please vote for it and offer comments and further suggestions if you need better support for analyzing dates in ArcMap.
Good suggestion - I would like to vote for your idea for improved ability to find Min and Max Dates and better perform subqueries in ESRI software, but when I click on your link to vote, it takes me to a dead link (sales force website). Do you know more about how to vote for this, or any recent developments? Thanks, Rachel P
I have edited the link in my post to be current to the url that appears in my browser when I pull up that idea on the Ideas site. Try it again. Or else just go to Esri Arcgis Ideas | Ideas Submission Portal and search for
I know this post is old, but I'm struggling to do what is simply the GROUP BY function in SQL.
I have a table (in a file geodatabase) of land parcels with sale dates - multiple rows in the table have the same parcel number but different sale dates - I need a query for records with the latest/most recent sale date). For various reasons I need to use File Geodatabase.
Can Model Builder in Pro 2.6.3 handle this without the need for additional tables, etc.? Thanks