Sumif like function in Knime

[ravi13]

Hi!! Knime Experts
Hope you are doing good.

I am stuck in following issue, please guide me which logic should i build to get answer…

Requirement;

Get sum of all rows where there is written ''Total Assets" ,"Shareholder’s Equity
" & “Total Liabilities” from following table

Paticulars	Found in	Code	Amount
Inventory- Stores & Spares	Balance Sheet	Total Assets	89
Current Assets	Balance Sheet	Total Assets	78
Inventory- Raw Material	Balance Sheet	Total Assets	-78
Inventory- Stores & Spares	Balance Sheet	Total Assets	98
Reserves	Balance Sheet	Shareholder’s Equity	1456
Trade Debtors	Balance Sheet	Total Assets	97
Trade Debtors	Balance Sheet	Total Assets	71
Non Trade Debtors	Balance Sheet	Total Assets	32
Current Assets	Balance Sheet	Total Assets	-59
Current Assets	Balance Sheet	Total Assets	78
Current Liabilities	Balance Sheet	Total Liabilities	73
Current Liabilities-financial	Balance Sheet	Total Liabilities	89
Eqity shares	Balance Sheet	Shareholder’s Equity	2500

Output required:

Code	Amount
Total Assets	406
Total Liabilities	162
Shareholder’s Equity	3956

[HansS]

Hi @ravi13

You don’t need no logic, only a GroupBy node.

gr. Hans

[ravi13]

Thanks @HansS I don’t think of that