Macro that does not require input isn't running because "No valid fields were selected"

[jmcconnell]

I have a macro in my workflow that does not require input but continues to error when trying to run because "No valid fields were selected".  I tried the Help/Learn More options but that explains next to nothing about how to resolve in regards to macros.  Any help/suggestions?

[FinnCharlton]

Hi @jmcconnell , so there are no records at all being passed to the macro? The macro input tool needs some records passed to it, or it will have nothing to pass to BigQuery output tool.

[jmcconnell]

It was referring to the Select tool.  When I selected it on the canvas all the previously defined fields were listed as "Missing", so I clicked on the Macro Input (Input Data) tool and clicked "Refresh" to pull in the data.  Now the Select tool doesn't say everything is missing however I'm getting the same error.  The macro itself runs on its own so I'm not sure what the problem is.

[jmcconnell · Accepted solution]

Okay so I solved my issue but I had to approach it in a totally different manner.  What I ended up doing was having one main workflow that starts with a text input and a batch macro that accepts the text input.  Inside the macro based off the text input I put my tools for each step in different containers and based off what step I'm on I enable/disabled the containers.