Insert Summary Tool output into Report Text tool

[carl_cimino]

I am trying to insert the count from a summarize tool into the Report Text tool.

the objective is to be able to get to this.

Currently can do everything but get that number in

Any suggestions would be helpful/appreciated.

[ChrisTX]

If you can get all of the Summarize output into one field and one row, try a batch macro with a Control Parameter.  

 

[CoG]

Alternatively, you can use the Append Fields Tool (or Join Tool if you use Grouping) to merge the count with the table data stream:

Then you can reference the count in the Report Text Tool (using "Available Fields" drop down:

Hope this helps and Happy Solving!

[carl_cimino · Accepted solution]

@ChrisTX  thank you for the suggestion I couldn't figure out how to do this method.

[carl_cimino]

@CoG thanks your method and sample workflow worked perfectly.  

[ChrisTX]

Also: There's an example under the section for "Creating a Text Snippet" in this Interactive Lesson: 

https://community.alteryx.com/t5/Interactive-Lessons/Adding-Text/ta-p/553705