Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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