How to sum a column with multiple conditions in Talend ?

[prabuj]

Dear Team,

@richard Hall @Xiaodi Shi

I have a requirement like this :

SUM ( COLUMN ) where a ='1' AND b= '2' AND CNO=DNO

How to achieve this in Talend ? Please provide me a example with sample data to understand it clear.

Thanks in advance.

[Anonymous]

Hi

Where are data from? If you are reading data from database, you just need a tDBInput component to run a query.

Regards

Shong

[prabuj]

Hi @Shicong Hong​ 

The data is coming from a csv file. Could you please help out with a example.

Thanks in advance.

[Anonymous · Accepted solution]

Hi

Take a look at tAggregateRow component, this component is used to perform aggregation operations including sum, avg, first, count etc..

Assuming a, b CNO, DNO are the column names in your case? I think you need to filter the data using tFilterRow before tAggregateRow.

Regards

Shong