Case-insensitive sorting of a list

Problem Description:

How can I sort a list of strings while ignoring case and accents?

Solution:

The sorting performed in ToD is generic, with a sorting policy applied equally to all text columns. Characters are thus sorted according to their code in the platform’s encoding.

For the Western alphabet, the codes are as follows:

It is therefore necessary to prepare the data to achieve a specific sorting in ToD. In our example, the goal is to create a copy of the target column, with its values being in lowercase and without accents, and then sort everything:

The transformation performed in the preparation editor is ‘Generative AI to transform data’ with the instruction : Create a new column with the values of the column "name" as TEXT, in such a way that the new column is a copy of it without accents and with values in lowercase

A sorting node was then added, using the new column ‘normalized_name’ as the sorting field.