Select distinct in many columns

[Anonymous]

I need to execute a query to find the distinct values from many columns:

Example:

SELECT DISTINCT COL_A, COL_B, COL_C FROM TABLE_EXAMPLE

Something simple i think, but i'm not able to find a way of implementing this in Talend for Data Quality. Do i need Talend Studio to accomplish that?

Thanks.

[Anonymous]

Hi
How will the values be used after it is read? If you want to output the values to a file or database, you can use a tDBInputXXX component to execute this query in a job with Talend Studio, it is easy to do it.

Regards
Shong

[manodwhb]

@Moe , You can do in Talend Data Quality it self select multiple columns and get the distinct values to know.

if you want to get output into file or DB, you need to use Talend data integration.

check the below link for more details

https://help.talend.com/reader/2OdJUxUo875vFjIX_3J2Rg/fyi5PPwsj95Mo1VeIBZ5QA

{Edited}