When I open the CSV file in JMP all the numeric turns into character and by changing column info the data either disappears or randomly changed into various incorrect decimal formats, should I try any other tools? methods to open the file?
In what type of format is your data in? Could it even be converted to a number? Could you share the .csv file?
For example:
unfortunately, I cant share the csv file, the data is 3 column the tag name, data and data points of an online measurement time series. The tag names and date info transfers properly, but data transfers properly in character format and when I change it to continuous, all I explained happens... here is a couiple od data points:
I also open data with using preview, It solved the problem without pushing any other change but I received this message, and since the data set has more tha 1 mil, rows, I am still not sure if the data transfers properly.
Random check however looks ok with data as continuous and decimals
Thanks, cammas are decimals in source data, the visual investigation is not a good solution to find odd values in such a big number of raws (15478), I prefer having 186 missing values... however this is a subset of much larger data, so 186 leave out from a sample can be much more in the big data without knowing the reason is not a safe situation, thats why I am looking for a proper import of csv files into JMP, I think I do not know all tips and tricks here in transfering data from csv to JMP
