Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
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 */
});
Solved! Go to 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.
Hi @Bhanu_Manoj.
Your question raises some potential concerns:
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.