Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Field adding its own information

Topic Labels: Data
730 6
cancel
Showing results for 
Search instead for 
Did you mean: 
SocialSyncBoost
4 - Data Explorer
4 - Data Explorer

Hello,

I am importing a csv file formatted: 390,390,390

The table does this: 390 390 2 390 3

It's including the number of 390 values in the import file

How will I fix?

 

6 Replies 6

Hi,
Check your CSV

Alexey_Gusev_0-1723757567071.png

 

Hi,

I did, this is the csv string: 320,390,390,390,480,590,590,590,590,

 

 

Please review attached

Do you need to create a new table or import new data in the existing?
I'm used 

Alexey_Gusev_0-1723971287499.png

and it's quite simple.
but if you need to use Extension to add data to existing table, you should include field names as a first row
You can use this code to generate if you have a lot of fields

Alexey_Gusev_1-1723971679871.png

 

console.log([...Array(15).keys()].map(n=>'KeyM'+n).join(','))

 


of course, this should be enabled

Alexey_Gusev_2-1723971809475.png

 



Hi, 

The extension requires a $20 plan. Not interested.

The file is a simple notepad, no headers

Can you tell me where the green toggle is located.?

This seems like a simple issue.

https://share.zight.com/eDuZzYJ8

I thought you used extension because usual add table function has no Field Map details like in your screenshot.
Now it's clear. I never used Import Data but it's almost the same as Import with Create new table.
Import function must know which field to use for which number, and it reads first line of csv as field names.

So, CSV must contain several lines and first is field names

And since field name must be unique, it adds extra numbers 2, 3 etc

Easiest workaround is to duplicate line in CSV, to have it like: 
320,390,390,390,480,590,590,590,590
320,390,390,390,480,590,590,590,590

and then in options select

Alexey_Gusev_0-1724047110790.png

The alternative solution is to Download CSV (in View menu) and use list of fields from it.