Report the count of rows after several filtering operations

[Soren_Therkel]

Hi everyone

I am doing a workflow for virtual drug screening and I would like to report the total nr. of molecules (essentially row count) at different steps in the workflow. E.g. at the beginning when loading in the dataset, after different following filtering operations as the nr. of molecules decreases when i remove duplicates, missing values, filter on different molecular factors etc.

Does anyone have a hint to the easiest way to do this with the “data to report” node?

Thanks

Best
Søren

[ArjenEX]

Hi @Soren_Therkel

Another user had a similar request some time ago. Have look around in that topic, some ways to approach this are described in there. Hopefully it provides some inspiration:

Is there an easy 'Visual' way to track # of records throughout a workflow with multiple joins?

Hi Everyone, Often my work involves a series of joins bringing together different datasets. Sometimes these joins will have unexpected results due to a variety of factors; none of which are KNIME’s fault. However, the key way I use to trace back and find the source of the issue is to look at the counts of records throughout. My current approach is to right click and check the properties of the nodes and then type the record count into the node description. This lets me visually walk through…

[Soren_Therkel]

Hi ArjenEX

Thank you, problem solved!