Remove duplicates from list

[kamaridesu]

Hi there!,

I really hope the comunity here is active, i have a problem that i been trying to crack for 1 week now 😞

basicly i have a list of languages that i get from a virtual column that find it in a parent table, and the result is 

so what i want to achieve is to remove the duplicates, and i already googled it and tried bunch of options like

but does not want to work, any ideas?

[Marc_Dillon]

SELECT has a third parameter 😉

https://help.appsheet.com/en/articles/2357314-select

[kamaridesu]

I know that select has a third parameter and it does not work, keep in mind that each record that i have is an enum list which means that every user has a column with lets say spanish, english etc... so when i select them what i get is rows of enumlists and the third parameter does not do anything

[Steve]

https://help.appsheet.com/en/articles/2357340-split

See Common problems.