Hi , i hope someone can help 🙂
I have a field which contains a list of numbers. This is a type: string
field that can have different cominations (x!) of numbers e.g. 1,2,3 or 1, 3,2 or 2,1,3 or 2,3,1 ect. However i would like to have it always sorted in asc order 1,2,3. Any Ideas on how to fix this?
Hi Poqy!
For sure! Can you please share us :
1.- SQL dialect you are working on
2.- SQL datatype of this field. (json, text, character varying, for instance)
3.- Are we using negative numbers (“-” symbol is present in the string)?
4.- Are we using decimals in this field?
A screenshot of the current LookML definition and sample of the data also can help.
Regards,
Leo