Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am searching for a possibility to filter my database already in the script.
In the end it should give me the result as I would set a filter in the document and use the "Data limitation" which only leaves all data that match to this filter.
Is there a simple solution that would work at the end of the load script?
Thanks in advance.
Hi,
I am thinking that you can filter the first table, and then use "where exist" function to filter the rest of the data.
Where Exists() and resident load
Best regards,
Cosmina
Hi Robert,
while reloading the application you can do filter in 2 ways
-->Use debug mode for limiting the data(No of records from each table)
-->by using functions Where exist (),Match()...etc
so choose and elect by yourself as per your convenient.