Hi, Is there a way to sort by a column and ignore ...
# gooddata-cn
a
Hi, Is there a way to sort by a column and ignore case sensitivity when in the Analytical Designer? For example if I have a table like below: Name i80 Idaho Isa Sixth SPC And I sort the table alphabetically, I find that it sorts like this: Name Idaho Isa Sixth SPC i80 I am using GD.CN version 1.7. Is there a way I can sort these so the letter i (lower case) is treated the same as the letter I (upper case)?
j
Iā€™m afraid this is not possible and this is sorting by default. I will submit a product feedback form on your behalf.
a
Thanks Joseph.
j
Hello @Alex Gertman! I think that you could add another displayForm (label) where those strings would be all lowercase, and you would apply sorting on that column instead ā€” do you think this workaround would work for you?
a
Thanks Jiri and Joseph! I think that Jiri's solution would work in the interim, as soon as we update to GD.CN 2.1.
šŸ‘ 1