Use SQL Statement as a analysis source rather than a Table (in Open Studio for Data Quality 7.2.1)

Highlighted
One Star

Use SQL Statement as a analysis source rather than a Table (in Open Studio for Data Quality 7.2.1)

I would like to use a sql statement as a source of analyzed data rather than the Table itself. Specifically I'd like to join two tables together and create a computed column using a group by.. and use that SQL output as the source for analysis.

Is that possible?

 

Thanks,

Matt

Highlighted
Employee

Re: Use SQL Statement as a analysis source rather than a Table (in Open Studio for Data Quality 7.2.1)

hi

i think the workaround maybe you can create a view first

then create analysis from the view

 

Regards
Jian
----------------------------------------------------------
Talend | Data Quality

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read