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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Regarding Query and EQFilter on infotables.

Bhanu_Manoj
9-Granite

Regarding Query and EQFilter on infotables.

Hi team,

 

I am trying to work on a large infotable. Which will be faster to filter the data Query or EQFilter?

 

filtered_table = Resources["InfoTableFunctions"].Query({
t: large_infotable/* INFOTABLE */,
query: {
"filters": {
"type": "EQ",
"fieldName": "field",
"value": somevale,
}
},
});

 

 

Resources["InfoTableFunctions"].EQFilter({
fieldName: "fieldname" /* STRING */ ,
isCaseSensitive: undefined /* BOOLEAN */ ,
t: large_infotable/* INFOTABLE */ ,
value: somevalue /* STRING */
});

 

1 ACCEPTED SOLUTION

Accepted Solutions

Performance will be almost same for both queries. As data is read from a csv file in infotable (memory). It doesn't make much difference. You will get case-sensitive extra option with EQ filter.

View solution in original post

3 REPLIES 3
slangley
23-Emerald II
(To:Bhanu_Manoj)

Hi @Bhanu_Manoj.

 

Your question raises some potential concerns:

 

  • What is the source of the infotable?  Is it coming from a datatable, stream, third-party database, etc.?
  • Since infotables are loaded into memory, how large is it?

We will be better able to answer your question once we understand more about your scenario.

 

Regards.

 

--Sharon

Hi Slangley,

 

I took the data from .csv file and pushed it into a temporary infotable. Later i am trying to compare a column in the infotable with a string.

 

col1  col2
hello hai
hello1 test
hello2  test
hello3 test2

 

Now I want to get the rows in the infotable where col2 = test. 

 

Regards,

Performance will be almost same for both queries. As data is read from a csv file in infotable (memory). It doesn't make much difference. You will get case-sensitive extra option with EQ filter.

Top Tags