Hello!
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!
Hello!
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!
Hi,
Attach “String Manipulation” node and apply an expression to count number of "\N"s in specified column:
count($column$,"\N")
to a new column (check “Append Column”).
Then Row filter rows with specified count.
Martin K.
Thank you!!