Upload bulk CSV in Database issue

Studio
1

Hi Platform team,

I found issue when I upload my csv file to database in studio. The issue below:

image
image1920×855 60.3 KB

I’ve already set all lowercase for column header as well as all data type is string. But the data still can’t upload. Please help to solve this issue. Thanks

as reference

  1. Sample CSV file
    https://cdn.yellowmessenger.com/85XfXeh8Rhvn1678243329046.csv
1 Like
2

Good day, @Andika_Januarianto. The first column resembles exponential notation. Could you try changing it to a number instead? Or if you need 3,67406E+15 as a string. Simply add it to a Google sheet, download it as a CSV file, and then try adding that.

Let me know if you are still facing issue.

3

Thanks bro. Solved it using the method add it to google sheet first then download as CSV file.