Question

Trouble parsing CSV file line items using Formatter

  • 31 August 2021
  • 2 replies
  • 212 views

Hi everyone,

I’m trying to import a CSV file from a new attachment in Gmail, but I’m getting some troubles using Formatter.

This is the sample CSV file:

 

And this is my Formatter set up:

 

The problem is that for every line item, Formatter is not assigning the values to the correct columns (header names):

 

 

 

 

Any help would be appreciated.

Thank you


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +11

Hi @eortiz, welcome to the Community! :)

It looks as though row 1 is blank:

4842a4ada710ce974f92097d825b0f05.png

I think that may be what’s causing some issues in Formatter recognising the header row correctly.

Can you try removing the blank row 1 from the CSV file so that the header names move up into row 1. Then try re-importing it using Formatter to see if that does the trick? 

Please do keep us in the loop on how that goes!

Hi @eortiz, welcome to the Community! :)

It looks as though row 1 is blank:

4842a4ada710ce974f92097d825b0f05.png

I think that may be what’s causing some issues in Formatter recognising the header row correctly.

Can you try removing the blank row 1 from the CSV file so that the header names move up into row 1. Then try re-importing it using Formatter to see if that does the trick? 

Please do keep us in the loop on how that goes!

Thanks @SamB but I am not able to edit the input file :(