Drop a reporting table tool if no information available to populate it

[Emma-Allwood]

Hi 

I've created a report which has multiple tables depending on the category the original data falls in to, these feed in to a layout tool via a multiple join tool. Not all tables are forced to be populated all the time, depending on the data that is input at the beginning. However, when this happens, rather than producing a report displaying only the valid tables or the valid tables plus an empty table... it produces nothing as it fails to join the blank table. Any idea? Thanks in advance

[mceleavey]

Hi @Emma-Allwood ,

put the tool in a macro and in a container. Add a control parameter to the lightning icon on the container.

In the Action tool, configure it to update value with a formula, and select the value=false line under "Disabled":

then click the button to the right of the formula.

In the formula window, configure as follows:

In your workflow, replace the table tool with this macro. Put in a Count Records tool separate to the input to the macro, and then from this tool connect that to the control parameter. 

In the macro, select the count of records as your parameter under the "Questions" tab.

This will close the box completely if there are no records, and will effectively tell the workflow to not produce the table unless there are records.

You will obviously need to consider macro output etc. if you need to continue the stream.

M.

[mceleavey]

@Emma-Allwood ,

alternatively, you can use a set of detour tools in the macro, rather then the container if you prefer.

M.