nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fields getting merged when importing table to gdb

BenjaminSimpson

Hi all,

I am trying to import several .csv files into a file geodatabase. Once I have finished importing the tables using the table to geodatabase tool some of the table have all the fields merged together. They are all seperated by an underscore. I have no idea why this is happening on some csv files but not others. I have imported multiple other tables to this gdb without any problems. Does anyone know why this might be happening?

Thanks,

Ben.

Encuentra más publicaciones etiquetadas con

Accepted answers

BenjaminSimpson

I have just discovered what the problem was. One of the field headers was missing which when entered correctly into the csv it now imports normally. Sorry I should have noticed this silly mistake. Thanks to both of you for taking the time to reply to my question.

All comments

JeffWard

Glad you were able to get it working.

BenjaminSimpson

Yer they are only separated by an underscore after they have been imported. The original tables do seem to be normal csv files, they are definitely comma separated when I view them in WordPad and every field has its own column in excel.

At the moment I am trying to import 4 tables (all csv files), previously when I imported earlier versions of these results, half of the table imported fine, the other half merged all fields into one. When I tried to import the latest results tables yesterday, all four tables had all their fields merged into one.

JoeBorgione

Jeff- one way the other, I don't think he has a csv....

JeffWard

Joe, I think he meant they are separated by underscores after the import and all in one field. That's what lead me to believe they are just separated by spaces instead of commas.

JoeBorgione

They are all seperated by an underscore.

Then it's not a csv. It's a underscore delimited file. Perform a search for _ and replace it with , in a text editor and you'll have a csv....

JeffWard

Are your field names and values separated by commas in your csv?

Are you able to post a sample?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Todas las Comunidades
Publicaciones Recientes
Contenido Seguido
Ayuda de la Comunidad

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.