How to delete rows matching multiple criteria
As I may receive mails with more than one attachment (e.g. an excel file and a jpg) I would like to delete all rows from the trigger attachments data table that don't contain an excel file to ensure further processing. Otherwise the pushbot will take the jpg file for further processing and dumps. With the Tables: Remove a Row action it is only possible to search for one criteria (e.g. jpg) but I would like to look up more than one criteria (e.g. jpg, jpeg, pdf, png, txt) . It would be even better, if it would be possible to delete all rows that aren't xlsx files. Is this possible?
Comments
-
Hi @Roberto_142863, it is nice to hear from you!
I checked the Tables section in the Catalytic Help action list. This section of the Help site shows there are a few options to work with the Trigger Attachments table. (Image and link below.)
Tables: Apply Filters outputs a new data table with the filter applied. Filtering the Trigger Attachments table should get you the one row you need for further processing.
Please let me know if that works!
Tables
https://help.catalytic.com/topics/actions/#tablesTables: Apply Filters
https://help.catalytic.com/docs/tables-apply-filters/0