# Recuperating valid and invalid rows in a table analysis

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

You can generate a ready-to-use Job on the results of a table analysis in which a business rule with a WHERE clause has been added as an indicator. This Job recuperates the valid or invalid rows and writes them in output files or databases.

## Before you begin

A table analysis with an SQL business rule has been created and executed. For more information, see [Creating a table analysis with a simple SQL business rule](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-table-analysis-with-simple-sql-business-rule).

## Procedure

1. Execute the table analysis.
2. In the analysis results, scroll down to the Business Rule Indicator section, right-click the rule line and select Generate Job.

   The generated graphic for the business rule is displayed accompanied with a table that details the matching results.

   The generated graphic for the business rule is displayed accompanied with a table that details the matching results. ![Example of charts for a business rule.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/table_analysis_recuperate_rows2.png)

   The Job Selector dialog box is displayed.
3. Select an option:
   | Option | Results |
   | --- | --- |
   | generate an ELT job to get only valid rows | Generate a Job that uses the Extract Load Transform process to write the<br>valid rows of the analyzed table in an output file |
   | generate an ELT job to get only invalid rows | Generate a Job that uses the Extract Load Transform process to write the<br>invalid rows of the analyzed table in an output file |
4. In this example, select the generate an ETL job to get only invalid rows option.

   The generated Job will output all the invalid rows in the table. The invalid rows are those that do not match the business rule used in the analysis (customers younger than 18).
5. In the dialog box, click Finish.

   The Integration perspective opens on the generated Job.

   The properties of the first component in the Job are predefined according to the database connection used by the table analysis.

   The properties of the first component in the Job are predefined according to the database connection used by the table analysis. ![Job using the tMySQLInvalidRows and tFileOutputDelimited components.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/table_analysis_recuperate_rows4.png)
6. Optional: Use a different output component and define its properties to recuperate the invalid rows in different type of file or in a database.
7. Save your Job and press F6 to execute it.

## Results

All rows of customers who are younger than 18 are written in the defined output file.