cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete duplicate rows from a infotable field ?

SOLVED
Regular Member

How to delete duplicate rows from a infotable field ?

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to delete duplicate rows from a infotable field ?

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

View solution in original post

2 REPLIES 2

Re: How to delete duplicate rows from a infotable field ?

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

View solution in original post

Re: How to delete duplicate rows from a infotable field ?

Thank you !

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________