Forum Discussion
CSV file issue
Hi, I'm trying to import a CSV file that is using commas as separator. But once I import the data, then some rows are separated and some not. If I try it in Excel, then it separates all the rows...
The problem was with the file. After downloading it from the source system, I didn't open and save it as a csv file anymore, but just took the file from the Downloads folder and now it works.
Hi Gazzer,
From where can I find the line breaks option, as when I import the file with Text/CSV option, then this is what I get:
You have to go back to the Source step after the initial import.
Go to the Applied Steps section on the right-hand side and click the little gear wheel icon next to "Source" to edit the import settings. It should look a bit like the image in my previous post.