Issue on Importing a File
I would like to ask this issue. I have never encountered this before so I hope you can provide me some insight.
This is the view of the file I am going to Import ini Excel mode(just a sample).
I do the usual Save as "CSV format". I open the CSV format and everything is fine. I proceeded in importing it to Anaplan and this is what I got:
I only have 1 column present. I tried to recreate the file over and over again and I still got the same issue.
Is this an issue in Anaplan or Excel. I just finish loading the other csv files that I have and there seem to be no problem just this one.
Appreciate the help.
I think it's not because of Anaplan. Try this,
#1. Delete the file source in Import data source
#2. Create a new one.CSV file and load it.
this happens when you have a special character in the file that is breaking the column separator logic. try to make a csv with something else than comma and see if it solves it.
or try to find that character....0
you might want to open with notepad++ and show special chars0
Check your delimiters if it is comma, pipe or anything else. Looks like Delimiter issue as @nathan_rudman highlighted
As all the bosses mention it could be a number of different issues...
One option you could try:
It is also possible that text encoding type is not the correct format sometimes selecting UTF8 works for me when the file is saved as a .csv utf8 format.
Alternatively you could try to save it as .txt file and upload it this way.