topic How to sum a column with multiple conditions in Talend ? in Talend Studio

How to sum a column with multiple conditions in Talend ?

prabuj — Fri, 15 Nov 2024 21:55:02 GMT

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 — Mon, 10 Apr 2023 14:08:55 GMT

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

Regards

Shong

prabuj — Tue, 11 Apr 2023 02:34:05 GMT

Hi @Shicong Hong

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

Thanks in advance.

Anonymous — Tue, 11 Apr 2023 08:24:42 GMT

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