Method for removing blank rows from a table
I'm looking for an easy method for removing blank rows in a data table. I would like to avoid any solutions that require batch processing each row if possible.
Best Answers
-
Hey, Kevin.
I'd use Tables: Apply filters with advanced filter logic to filter out rows with null values, depending upon whether a new table will suit your process needs.
Thomas
5 -
Thanks @thomas, that's exactly what I needed!
0
Answers
-
@Thomas_937381 Is there a screenshot you could share? I tried to use your suggestion, but it's not working. I must be doing something wrong.
Thanks!
0 -
Hi @Anna_272419, welcome to the Community!
I noticed
IS_EMPTY
in the action setup instructions.In the help article, I noticed the use of
!IS_EMPTY
and this worked as expected. I have a few screenshots for you below.Tables: Apply Filters
https://help.catalytic.com/docs/tables-apply-filters/#how-to-configure-this-action1