Forum Discussion
Helper IIIColumn values are shifting after csv files are loaded
lc1 OK, but I need the text. Like, open the file in Notepad. Copy, paste.
Thank you Greg_Deckler , I was able to see the errors when I open the file in Notepad.
Community Championlc1 OK, what are the errors? Have you clicked on "View errors" and investigated? Typically these are due to bad data. For example, let's say you have a Year column with numbers like 2023, 2024, etc. but for some of the rows you have text like "N/A". If the column is set to be numeric versus any, then you will get an error for that cell for that row.
Helper IIIGreg_Deckler I did, two of the errors I can resolve, but the other 17 have me a little confused because they are correct in the dataset (csv folder), only when loaded is that the values get moved to other columns.
- Greg_Deckler
lc1 Right, so sounds like the format is different or you aren't account for text qualifiers. For example, maybe there is a missing comma or separator in that particular row. Or, you have something like:
"Foo", "Bar", "Foo, Bar"
If you don't account for commas in your text qualified by double quotes this will result in 4 columns, not 3 for example.
Pretty much impossible to know with the information provided.
- lc1
- Greg_Deckler
lc1 OK, but I need the text. Like, open the file in Notepad. Copy, paste.