File match : filter data in a table

[Dembegomes]

Hello everyone,,

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 ?

[Dembegomes]

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 ?

[martinpohl]

hi,

I would load the ID as a concat-string

load concat(distinct Field,',') as Concat
from your table;

then get the string as a variable
let vFilter = peek('Concat');

and use this variable as a filter in the select

select * from table

where ID in ($(vFilter));

Or something similar

Regards