File match : filter data in a table

[arjunmadhusudan]

I have a table with fields ID name  and sales with over 400k records 

I get files with ID usually having 300 IDs in each file.

I need to filter the table as per these IDs

It is a published app and there is no provision to store the excel file on the server 

Can I use variable extension or qsvariable ?