Latest Contributions by DanPatterson_Retired

Sounds like you aren't going to find a one-script-fits-all solution. You might have to process and fix in batches... like finding all those records that begin with a "B", then doing those, and finding out how the rest differ. ... View more

That has to be the most convoluted process to produce a "bug" I have ever heard!   kudos! ... View more

Alycia Rajendran‌ what did you have to do to reproduce it, when I can't?  Data source? License? Proximity to Greenwich? ... View more

good luck especially for the full address bit, there are other services and databases world-universities-csv/world-universities.csv at master · endSly/world-universities-csv · GitHub  has a listing, in csv format which is about 4 years old Then there is wikipedia Lists of universities and colleges by country - Wikipedia  ... View more

Table To Table—Conversion toolbox | Documentation  but dbf, csv or txt are the output options and from here Frequently asked questions—ArcGIS Pro | Documentation  Can I use personal geodatabases (.mdb) as data sources for ArcGIS Pro? No. Personal geodatabases are not supported in ArcGIS Pro, so you cannot use personal geodatabase datasets as inputs for geoprocessing tools or create those datasets as outputs. File geodatabases are fully supported and are the default workspaces for ArcGIS Pro projects. ... View more

in a script  you can set the parameter as "derived", so if the parameter is a "field", the values that are available would be "derived" from the input dataset.  I dont know if it applies to modelbuilder ... View more

Access isn't supported in Pro or Map, you will have to do that elsewhere ... View more

can you post table (dbf or gdb, csv or excel sheet) with a couple of rows. It is easy to do with python and numpy using TableToNumPyArray and processing the array. You have to repeat the number of cities by an unknown amount. parsing the cities isn't a real problem, setting up the repeats needs to be tested unless you know that there will always be 2 cities, no more, no less. a = np.asarray([["University of Leeds", "Leeds;United Kingdom;Europe|London;United Kingdom;Europe"]]) [i.split(";")[0] for i in a[0][1].split("|")] ['Leeds', 'London']‍‍‍‍‍ ... View more

are there other data associated with each row? or is that it? ... View more

Good idea.... Mar 07, 2018 was the last time the first "bug" was updated. ... View more

between lines 25 and 26, add a  print("Layers found {}".format(Input_workspace))‍ If you get nothing, then the input workspace isn't any good, or it isn't a full path. Also add a  print("Layer name {}".format(Layer.name))‍ on line 26.5 Also /blogs/dan_patterson/2016/08/14/script-formatting  so people can copy and paste your code and have it formatted properly.  Screen grabs can be use. ... View more

Glad it worked out James ... View more

Duncan, I did it with a clean project, just a standalon table, I followed my images (there are several) and it has worked with several different tables in several existing or empty projects.   I think it might be time to move it to a right-click whenever you click on anything in a table column ... View more

Contact the people that wrote the lesson (If they are listed) or tech support, there seems to be a lot of fiddly stuff with those deep learning and related modules ... View more