Hi Everyone,
My workflow has a few basic filters and calculations to create three different tables that are combined into one email output. Each of these three tool groups are filtering to find a list of records that meet certain criteria each month, but there is a possibility of no records matching the criteria in a given month, meaning the table output would be empty for one or all of these tool groups.
I am running into an issue where if one or more of these table outputs are blank (meaning there are no records matching the filter criteria from the steps above), the email output does not send. I am assuming this is because of the empty table, but I would like to send and include the empty table (with column headers) in the email output to show that there are no records in the table.
Can anyone advise on how I can fix this or what could be causing it?
@taliatest
One way to handle it would be to add a Count Tool and if it equals zero then you will have a text, no data available and in that way there will be some text in the table.
@OTrieger Thanks for your help! Are you referring to the count records tool? So for example, in the 'Filter Active User List to Users with No Department Listed' tool group, would I add the count record tool after the select tool and then connect it to the table tool below?
Sorry if I am totally off base here - I am an Alteryx newbie.