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

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

msweetnam — Sat, 16 Nov 2024 03:37:31 GMT

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

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

msjian — Tue, 14 Jan 2020 08:50:07 GMT

i think the workaround maybe you can create a view first

then create analysis from the view

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