How to perform following operation in knime

[nidhichirania]

I want to use maths aggregation formula for some cells

I know, how to do this in SQL but please help me with how to do same in knime

(Select Column1 from table1 where column2=“a”)+((select column1 from table1 where column2=“b”)*(select column1 from table1 where column2=“c”))

Please help!

[iperez]

There must be a better solution but I would first filter the rows that match the conditions and then do the operations: Row Filter+Math Formula.

[ipazin]

Hello @nidhichirania,

not sure I understand how to apply your formula to data. Can you try explaining it with example?

Note: From experience ideas/suggestions/solutions come faster and are more complete with input data (dummy works just fine) and desired output provided including logic behind it if not obvious

Br,
Ivan

[bruno29a]

Hi @nidhichirania , how many records would each of the select statements return?
Select Column1 from table1 where column2=“a”
select column1 from table1 where column2=“b”
select column1 from table1 where column2=“c”

I’d also re-iterate what @ipazin said “ideas/suggestions/solutions come faster and are more complete with input data (dummy works just fine) and desired output provided including logic behind it if not obvious”