CSV Parse Issue

How To
1

Hello Make! I got stuck in a scenario that should have been simple:

  1. Get a .CSV from a FTP
  2. Parse .CSV
  3. Write data parsed on a google sheet

CSV parsing cause this error

Number of columns on line 12 does not match header

Column number in settings seems not to work for me: i have 6 columns and 11 lines of data but Make says on line 12 number is wrong. Setting an higher number, i have the same error

Number of columns on line 12 does not match header

Tried also "ToString - Data - " but nothing changes

Where i am getting wront? :smiley:

Many Thanks for help!

2

Hi Lorenzo,

I am having the same issue - did you figure it out??

3

Hello Lorenzo,

It just sounds like a data issue…possibly whatever service is creating the CSV file is not creating it correctly.
If you’re able to post the CSV file, or any other that causes this same problem, we can possibly help you identify the issue.

2 Likes
4

I found this issue only occurred when running an individual module in edit mode. When I ran the whole scenario the error did not occur. Very odd.