Skip to main content
B
Bhanu_Manoj1-Visitor
1-Visitor
November 20, 2020
Solved

Regarding Query and EQFilter on infotables.

  • November 20, 2020
  • 1 reply
  • 3139 views

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 */
});

 

Best answer by abhiramk

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.

1 reply

S
slangleyCommunity Manager
Community Manager
November 20, 2020

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

B
Bhanu_Manoj1-VisitorAuthor
1-Visitor
November 23, 2020

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,

A
abhiramk1-VisitorAnswer
1-Visitor
November 26, 2020

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.

Terms & ConditionsAccessibility statement