Format List

[poqy]

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?

[leobardor]

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