Dimension values are coming as " ? " (question mark) in sheets instead of number format

Mapuna — Mon, 02 Jan 2023 09:46:17 GMT

Hello experts,

Kindly try to answer my question in the below link:

Re: Dimension values are coming as " ? " (question mark) in sheets instead of number format

vinieme12 — Tue, 03 Jan 2023 07:17:47 GMT

This is because the same column has conflicting datatypes

for example first few rows loaded as NUMBERS and then subsequent data was loaded as TEXT

If you are confident all values are NUMBERS try to force the format as

Num(FieldName) as FieldName

Try to verify there are no garbage characters or force numbers using keepchar()

keepchar(FieldName,'0123456789') as FieldName