Dear Ted, exactly this is the point. How could I fix this issue?
Best, Paolo 2016-01-23 23:27 GMT+01:00 Ted Dunning <[email protected]>: > Andries, > > But if you set Excel to use , as the decimal separator, then 925.0000 could > be displayed as 925,0000 > > Guessing by name, I suspect that Paolo is European and might have Excel set > this way. > > > > On Fri, Jan 22, 2016 at 9:26 AM, Andries Engelbrecht < > [email protected]> wrote: > > > What does the JSON data look like? > > > > I did a quick test with Excel and MS Query through ODBC to connect to > > Drill. > > > > Selecting data as either a string or numeric value. > > > > select * from (values('925.000',925.0000)) > > > > The results returned is > > 925.000 for the string value and 925 for the numeric value to Excel. > > > > > > With Drill 1.4 you can use typeof() to see what data type it being > > interpreted as. > > > > --Andries > > > > > > > > > On Jan 22, 2016, at 8:50 AM, Ted Dunning <[email protected]> > wrote: > > > > > > This sounds like this might be a problem of decimal point separator. > Can > > > you say what decimal point character you normally use? It might also be > > > that this is set differently on the exel machine from the machine where > > > drill is running. > > > > > > I am presuming that the value that you want to see is 925.0 > > > > > > Is that correct? > > > > > > > > > On Fri, Jan 22, 2016 at 6:33 AM, Paolo Spanevello < > [email protected]> > > > wrote: > > > > > >> Dear All, > > >> i'm drilling a JSON File with some fields with numbers with this > format > > : > > >> > > >> 1s_critical_power > > >> 925.00000 > > >> > > >> > > >> I'm using ODBC Driver to connect it on excel and the result aspect is > > >> > > >> 1s_critical_power > > >> 925,00000 > > >> Do you know the right way to have it? > > >> > > >> Best regards, > > >> Paolo > > >> > > > > >
