topic How to count the number of tools in a workflow? in Alteryx Server Discussions

How to count the number of tools in a workflow?

Nico67543 — Tue, 16 Apr 2024 07:33:02 GMT

I have a lot of workflows and I want to count how many tools are used in each workflow. Is there any way to do that?

For example, there are 11 tools in the workflow shows below, and I don't want to count it manually.

Re: How to count the number of tools in a workflow?

Christina_H — Tue, 16 Apr 2024 08:48:27 GMT

You can use a workflow as the input for another workflow, read as a CSV file. Filter the output to rows containing "Node ToolID", which should give you one row per tool.

You'll probably need to tweak the input to get it working correctly, e.g. increase field length, set delimiter to \0, no field names.

Re: How to count the number of tools in a workflow?

fmvizcaino — Tue, 16 Apr 2024 14:13:33 GMT

Hi @Nico67543 ,

@Christina_H suggestion is a nice approach and allows you to retrieve more information about each node if needed.

If you only need to count the number of tools and nothing else, you can use this sample macro here.

Best,

Fernando Vizcaino