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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

How to delete duplicate rows from a infotable field ?

Aleksandar
10-Marble

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

ACCEPTED SOLUTION

Accepted Solutions

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

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

Thank you !

Announcements


Top Tags