How to count yes/no in Talend

[Anonymous]

I have a table containing a column with values Yes,No or N/A. I want to count the number of Yes and Number of No in that table and add that value in a different table in such a way that, the new table has one column with count of Yes and other column has count of No.

[Anonymous]

Hi
Read the data of this column from database, and use tAggregateRow to count the number of each value, set this column as group by column. About AggregateRow component, please refer to the component documentation on Talend Help Center.
https://help.talend.com/reader/Xr~HqMTCU7gC3dT5ZSikKQ/tq67T06xho7FrkCyFcLfbw

Please try and let me know if you any questions.

Regards
Shong

[billimmer]

Something easy you can do.  Use a query similar to this in your tDBInput component:

SELECT
(select count(*) from mydb.myschema.mytable where myfield = 'YES') as "Yes Column",
(select count(*) from mydb.myschema.mytable where myfield = 'NO') as "No Column";

write the results to a new table with tDBoutput....

tDBInput -----main------>  tDBoutput