Regarding Query and EQFilter on infotables.

[Bhanu_Manoj]

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

[slangley]

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

[Bhanu_Manoj]

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,

[abhiramk · Accepted solution]

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.