How to delete duplicate rows from a infotable field ?

I have a field with a values for example

worker

manager

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

worker

manager

Best answer by TanmeyTWX

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

Answer

17-Peridot

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

Author

1-Visitor

Thank you !

Sign up