Problems with google sheet as sql database SELECT column alphanumeric

estoy tratando de ejecutar una consulta a una columna de datos que contiene datos numericos y alfanuméricos. y solo me trae los datos numericos.


Please, help with this.

Thanks.

I am trying to execute a query to a column of data that contains numeric and alphanumeric data. and it only brings me the numerical data.

Ready!

You can't. Query is expecting a consistent set of data (e.g. all numbers or all text) in a google sheet column. best you can do is filter/sort the column/s accordingly before querying. Or set all the numbers to strings.

Thank you very much!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.