How to delete '\N' in rows by using row filter node


My data has a lot of ‘\N’ in each cells. I want to delete all rows that contain ‘\N’ using Row Filter, but I have no idea how to work it. Anybody can help me? Many thanks!


Attach “String Manipulation” node and apply an expression to count number of "\N"s in specified column:


to a new column (check “Append Column”).
Then Row filter rows with specified count.

Martin K.

Thank you!!