I have a excel file which contains 4 columns. With these three columns I would like to create patterns. Name | Surname | Birthday | Country
So now there are some rows which are filled with all 4 information, but also row where for example Birthday is missing or a row where Surname and Country is missing.
I would like to filter out all rows where, missing values are included. I have tried it with the missing value column filter but it didn’t work.
The attached workflow i believe does what you want with the Missing Value node - the salient functionality is, admittedly confusingly, on the 2nd tab of the configuration dialog – not the one you see when you open the dialog.
In this case yes - the node is originally intended for a purpose “grander” than filtering out rows and since it’s not performing everything it was intended to do, it will complain to you about it.
I don’t know what your data source looks like, but given that you know what generates the missing cell values (as you have the original XLSX file which did) perhaps you could provide the same empty content in this input?