How to delete duplicate rows from a infotable field ?

[Aleksandar]

I have a field with a values for example

worker

worker

manager

manager

and I want to delete those duplciates so the result in field will be

worker

manager

[TanmeyTWX · Accepted solution]

Hi  Aleksandar,

What exactly is your requirement?

If you want to just display unique rows out of an Infotable,you can use below Distinct Snippet.

var params = {
t: undefined /* INFOTABLE */,
columns: undefined /* STRING */
};

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].Distinct(params);

Regards,

Tarun

[Aleksandar]

Thank you !