CSV Importing Issues

Issues
#1
  1. When importing from the filesystem, you are unable to import a zip file, although it works with remote (URL based) sources.
  2. When importing a CSV that has a numeric field with commas for digit grouping, Exploratory presumes it character data, and even setting the digit grouping manually to a comma doesn’t fix it.
#2

Hi Kristofer,

Thank you for reporting the issue.
Regarding 2), could you try the “Decimal Mark” as Comma(,)

image.png554×804 29 KB

If it does not work is it possible to share me sample CSV that causes the issue?

Thank you
Hide

#3

Hi Kristofer,

It seems the data contains trailing “+” mark at the end for some rows.

image.png2434×1552 270 KB

So you can import the CSV then convert the data type to numeric.

image.png2000×1132 164 KB

#4

Also as for the zipped csv import, we don’t officially support it yet. I’ll put that on our enhancement request list.
Thank you for your suggestion.

Hide