Hi, I am very new to Knime tool and stuck at very basics itself. I have a table where I need to count null (for string datatypes) and 0’s(for Int data types ) in all the columns and get the error percentage of that.
Input is like below table:
I’m expecting that the output as:
Count of Null found in column A = 2
null error% for column A = (8-2/100 = 0.06 )
Same goes for column B for number of 0’s
Hi @rgupta01 -
I’m moving the topic to the main Analytics Platform forum for better visibility
I created a workflow count null_value in column.knwf (60.9 KB)
This flow splits the data into 2 groups; strings and integers. Then every (string/integer) column goes through the same loop en identify the “0” and the “null” . Via an GroupBy node the percentage (or better the mean) is calculate to identify the partition of “0” and “null” . In the end all the results-columns are collected together. Does this help you?
@HansS, It worked really well. Thank you so much I would be able to start now with Knime !!!
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.