topic Re: Select distinct in many columns in Talend Studio

Select distinct in many columns

Anonymous — Sat, 16 Nov 2024 04:08:05 GMT

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.

Re: Select distinct in many columns

Anonymous — Mon, 18 Nov 2019 08:08:50 GMT

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

Re: Select distinct in many columns

manodwhb — Mon, 18 Nov 2019 08:52:42 GMT

@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}