i’m sorry. I’ve come up with a supposedly simple question, but despite research and attempts, I’ve been unable to answer it. I am just switching from Excel/Access to Knime. Analogous to the “count-if” function or “sum-if”, I would like to analyse my data.
In Knime I have tried the nodes “Value counter”, “group by” or “maths”. The value counter already brings me to the goal without an “if attribute”. However, I no longer have the original table available.
So I am looking for a node that searches “flat” for the number in a column in the corresponding row.
I hope someone will take a moment! Thanks in advance!
I would now like to add an additional if-condition or extend the counting range via two columns. The if-attribute here is simply cell content from column Value.
If I understand you correctly, you want the original table but with the count of the occurrences of each value?
ok. so what you need to realise is that just because you’ve used the Value Counter, you can still bring the info from that back into another node along with your original table by using a Joiner node. So take a dataflow as in the attached workflow and join the original data table with the output from Value Counter using the “key” columns from both tables. You can take multiple flows OUT of each black triangle on a node, but only a single data flow can flow IN to any one black triangle on a node.
This works perfectly! I had the Joiner in my hands. But I could not set up the table. Thank you very much. This is getting me further! Have a nice day!
You’re welcome. Coming from Excel and other databases can make workflow/data pipeline tools seem odd at first, but after some playing around it becomes much easier.
Thank you! I was looking for the option but did not regonize! I think now I did it right!!!
Thank you for the welcome! I will look the Cell Replacer as well!
