Table Tool Output Issue

Question

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?

dreldrel · Answer

You can use a text input tool to add a blank row to your tables by union, so this ensures it always has tables in the output. If this helps, please like the comment and select it as the solution

lwolfie · Answer

Did you end up figuring this out?

taliatest · Answer

@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.