Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
we have noticed that if a string is having whitespace and if we export this into a CSV or an excel, we are getting strange characters in the excel.
could you please check the attached document and help if we can solve this issue as we are seeing data discrepancy between the excel and the data set contents
It looks like your Excel file was not attached properly. In any case, this is likely caused due to a character encoding issue. You should ensure that Excel is using the same encoding to read the data as it was saved. You can read more about how to do this here:
You can check what the character encoding DSS is using to write the CSV file under the “Settings > Preview” tab, in the “Charset” entry. By default, it is utf8.
Do let me know if you have any further questions about this. I have attached a couple of images for your reference.
Juan Eiros Zamora
Technical Support Engineer, Dataiku
How does the data in MS SQL get written to the CSV file that you then read with Excel? That unloading process would determine what character set is used to write the CSV file to disk. You need to find out what encoding is used to write the CSV data, and then use that to read it with Excel.