Incomplete values in csv import

Answered

Comments

2 comments

  • Comment actions Permalink
    Official comment
    Avatar
    Niklas Schmidtmer

    Hi Emmanuel,

     

    would you be able to share one of those CSV files from the data source (you can shorten/anonymize the content)?

     

    Also, it would be interesting to know if this is an issue with how the columns are displayed, or if the data is actually truncated. To verify this, could you please export the result of your query from above via the Studio by clicking on the "Export to CSV file" button? In the CSV file that gets generated, are the rows also truncated?

     

    Thanks

     

    Niklas

  • 0
    Comment actions Permalink
    Avatar
    Emmanuel Owosekun

    Hi Niklas, 

    after some investigation we've discovered

    that the respective file is encoded in UCS2 (SMS-Encoding). 

    We have recoded the file to UTF-8. 

    So my problem is solved for now.

    There's a similar request from my colleague. He shared a csv-file in UCS-Encoding (Post "UCS2-Kodierung von CSV-Dateien"). 

     

    Thanks a lot! 

     

    Emmanuel 

Please sign in to leave a comment.

Powered by Zendesk