i have a small Alteryx flow which I use everywhere. It gives me the number of Null values, the number of Blanks and the Non-null values, and a small formula calculate the completion rate : (non null values/total nb of rows)*100.
this little flow is really handy and I copy paste it in every new job.
I have tried to do the same with knime but cannot manage. Ideally I’d like to have it as small as the alteryx one and to be able to copy-paste it in every new job.
Here is what I did so far :
I entered a csv file with lots of columns.
I started with a Column filter node to select the columns
then I used a GroupBy to Count the entries and the Missing value count to count the blank and null values.
then I thought I could use a Math formula node to calculate 1) the difference between the total number of entries and the missing ones and 2) the Completion rate (non null values /total nb of values)*100
I do not find the right node to calculate the completion rate
Could you please bring me some help?
many thanks
Esmé
Thanks for sharing your approach—honestly, it already sounds like you’ve covered most of the groundwork!
Using the Column Filter, GroupBy, and Missing Value Count is exactly the right logic for getting what you want. The only piece you’re missing for the completion rate is a way to combine and calculate from those values in a dynamic way—and you’re almost there.
If your counts are already side by side (e.g., in one row), it should be quite straightforward with the Math Formula node. Just make sure your columns are well aligned—e.g., Total_Count and Missing_Count like I manipulated in my flow.
If you prefer a more compact flow (like your Alteryx version), consider wrapping this logic inside a Component so you can easily drag and drop it into any new workflow. That way, it behaves just like your “copy-paste” Alteryx piece.
But honestly, what you’ve done already is pretty much 90% of the way there. Just needs that final small tweak.
Please check the screenshots and sample flow below.
No worries, glad it worked!
If you think my answer solves your issue, feel free to mark it as the solution so it can help others who come across the same question later on.
