Convert text to number from a folder data

soyrbto

I’ve got response from the Product Team.

Works as designed. The editor never shows more than 1000 rows, and may show less when the data is large. Further, the editor only uses ~200 rows for type inference. Lets assume that the data is small enough so that we will get exactly that many rows. The editor looks at the first 200 rows and sees that all of the values can be converted to numbers. So it inserts a step to do so. Then, the editor runs the query against the first 1000 rows and all the conversions work. But in the 4000th row, there's a value in the column which can't be converted -- so that row produces an error value. The user has two options: either edit the formula so that the value is not converted to a number any more or fix the input data (which may be in error). The user may also do more complicated things by writing more formulas by hand.

Best Regards,
Herbert