Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I m using Talend data quality tool for profiling. I need to extract sql query generated during data analysis for e.x. - the analysis on some particular table says there are 10 rows with null asset_id and when I right click to see those ten records,it shown those records and a query which generate those 10 records. I want to extract that query, can anybody suggest how to do that.Below screenshot shows the sql query i need to extract. Will appreciate the quick response as I need to work on it.
Thanks
Aanchal
Hello,
In the SQL editor, click the save icon on the toolbar to save the executed query on the SQL business rule and list it under the Libraries > Source Files folder in the DQ Repository tree view.
For further information, see Saving the queries executed on indicators.
Best regards
Sabrina