Skip to main content
Committed ⭐️
grc5084
Committed ⭐️
Nov 15, 2023 8:57 PM UTC
Solved

Uploading CSV to Staging Area

Hello,

I have been trying to load a CSV file into a table while going through the Cognite Data Fusion Fundamentals course. I have tried for over an hour to load the data correctly. One of the column headers adds 2 commas after the text and is throwing off the SQL formula. 

I am using the stock CSV file provided in the course, loading it straight from my desktop and not making any changes to the file itself. 

 

 

    Dilini Fernando
    Dilini FernandoAnswer
    Expert ⭐️⭐️⭐️⭐️
    Nov 30, 2023 8:00 AM UTC

    Hi @grc5084,

    I hope the above helped. I’m closing this topic now, please feel free to create a new post if you still experience problems.

    Best regards,
    Dilini 

    View in thread

    4 replies

    Seasoned ⭐️⭐️⭐️
    Rajendra Pasupuleti
    Seasoned ⭐️⭐️⭐️
    Nov 16, 2023 7:03 AM UTC

    Can you please share the file or link for the course so that I can try to help you. I tried to upload multiple file prior and it worked for me. 

    Practitioner ⭐️⭐️⭐️
    Rahul Kumar
    Cognite Academy Instructor
    Nov 16, 2023 10:01 AM UTC

    Hello grc5084, 

    Thanks for posting your question here.
    CDF solution is working fine, please can you try again to upload the in the CDF-fundametal project in CDF.
    Make sure to download the file from the lesson attachment and follow the course instructions.

     

    Regards
    Kumar

    Rahul Kumar
    Dilini Fernando
    Expert ⭐️⭐️⭐️⭐️
    Dilini Fernando
    Expert ⭐️⭐️⭐️⭐️
    Nov 23, 2023 7:57 AM UTC

    Hi @grc5084,

    Did the above help you? 

    Br,

    Dilini 

    Dilini Fernando
    Expert ⭐️⭐️⭐️⭐️
    Dilini FernandoAnswer
    Expert ⭐️⭐️⭐️⭐️
    Nov 30, 2023 8:00 AM UTC

    Hi @grc5084,

    I hope the above helped. I’m closing this topic now, please feel free to create a new post if you still experience problems.

    Best regards,
    Dilini 

    Terms & ConditionsAccessibility statement