Filter in Script

[robert_gansel]

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.

[Anonymous]

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

[ramasaisaksoft]

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.