topic Re: CSV in model builder in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312466#M10814 <HTML><HEAD></HEAD><BODY><SPAN>Yeah that's actually what my first step was and it keeps returning an empty output.</SPAN></BODY></HTML> Fri, 21 Mar 2014 14:34:42 GMT KyleHahn 2014-03-21T14:34:42Z CSV in model builder https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312464#M10812 <HTML><HEAD></HEAD><BODY><SPAN>Good morning,</SPAN><BR /><BR /><SPAN>Just having some issues and thought I would ask for some help. What do you all recommend for getting a .csv file into a "more useable" format? I have a file with roughly 10,000 records. Just need it for some simple selection or querying within model builder and I can't seem to find the tool or combination of tools to help get the file into an easy to use format. the table doesn't contain any spatial data I should add. </SPAN><BR /><SPAN>any help is greatly appreciated.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Fri, 21 Mar 2014 13:15:25 GMT https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312464#M10812 KyleHahn 2014-03-21T13:15:25Z Re: CSV in model builder https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312465#M10813 <HTML><HEAD></HEAD><BODY><SPAN>Kyle,</SPAN><BR /><BR /><SPAN>Use the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//001200000027000000">Table to Table tool</A><SPAN> to convert your CSV to a File GeoDatabase Table.</SPAN><BR /><BR /><SPAN>Duncan</SPAN></BODY></HTML> Fri, 21 Mar 2014 14:27:58 GMT https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312465#M10813 DuncanHornby 2014-03-21T14:27:58Z Re: CSV in model builder https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312466#M10814 <HTML><HEAD></HEAD><BODY><SPAN>Yeah that's actually what my first step was and it keeps returning an empty output.</SPAN></BODY></HTML> Fri, 21 Mar 2014 14:34:42 GMT https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312466#M10814 KyleHahn 2014-03-21T14:34:42Z Re: CSV in model builder https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312467#M10815 <HTML><HEAD></HEAD><BODY><SPAN>Ok my issue I believe is I didn't have an objectId in the table. now is there a way to add that into the existing csv in modelbuilder?</SPAN><BR /><BR /><SPAN>thanks for the help.</SPAN></BODY></HTML> Fri, 21 Mar 2014 14:40:31 GMT https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312467#M10815 KyleHahn 2014-03-21T14:40:31Z Re: CSV in model builder https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312468#M10816 <HTML><HEAD></HEAD><BODY><SPAN>By running the Table to Table tool and storing the output table in a File GeoDatabase you will automatically get an OBJECTID field as all tables must has one in a GeoDatabase.</SPAN><BR /><BR /><SPAN>If you are getting empty output then this should suggest your CSV is corrupt in some way, such as blank rows, invalid syntax etc.</SPAN></BODY></HTML> Fri, 21 Mar 2014 15:57:35 GMT https://community.esri.com/t5/geoprocessing-questions/csv-in-model-builder/m-p/312468#M10816 DuncanHornby 2014-03-21T15:57:35Z