Importing Errors / Socrata
I don't have a large expertise on this topic, but I've used some Data Prep tools before.
There is one open data portal of an agency in Texas provided by a solution called Socrata.
But I'm having errors when importing the tool to Rapid Miner.
I already tried exporting CSV, CSV for Excel, TSV... In all the cases the are many importing errors...
I remember a conversation with a peer that worked on the same file months ago and told me he found, some "," (not sure if additional and/or missing) on the databases creating discrepancies and columns errors when importing.
Any suggestion about how to solve that?