Reporting: Create Table and Render file only if records exist

[jstavares21]

Hello Alteryx Community, 

I am aware of how to create an output file only if records exist. But I am wondering if there is a way to create a Report Table, and henceforth, only include the layout into a Render if records exist. Here is my long winded attempt to explain myself:

Filter 706 is searching for records where the [Usage Type]= “Sale of Fuel”. I am using Add Totals 702 (a Crew Macro) to add a total row & column after the filter:

In this set of data, Filter 706 produces no true records – no totals are calculated either. Therefore, when I push the data from the Add Totals tool 702 into the Table 678 tool contained within Container 722, I get an error at the Join Multiple tool 680 because there is no data for Table 678 :

After container 722, I am using a join multiple tool  to put together several layouts - including Layout 735 - (see below) and render one file.

Right now, I am not able to render a file at all because Layout 735 that is supposed to be produced in Container 722 is not working.

I would like to be able to keep these tools available for use in case true records exist at Filter 706 – yet not cause an error – and still render a file -  if there are no true records at Filter 706.

I appreciate any help my fellow Alteryx community can provide!

[apathetichell]

You cannot include an output tool like a render in a container... but you can in a DETOUR or in a macro... So just swap it into a detour or put the true side of a filter into a macro which calls the layout/render.