Standard macro with schema changed based on the data being fed into the macro

[Wesley Mendonca]

Hi everyone!

I would like to know how to process a Standard macro with outputs that have different schemas. The only change between each output is the number of fields.

My macro essentially replaces a SQL query from a dynamic input connected to a MongoDB database.

I tried using the option "Output fields change based on macro's configuration or data input," but it still doesn't work.

[Raj · Accepted solution]

@Wesley Mendonca 
instead of dynamic input tool have you tried with input tool and making changes to it
a reference batch macro has been attached
hope this helps.

[Wesley Mendonca]

Thank you, @Raj .

It worked very well!

[Wesley Mendonca]

@Raj , is there any way to record the paramenters that is used as input in my sql query? in a new column between the final resul? 

[Raj]

@Wesley Mendonca 
do you have parameter in query for input field?

[Wesley Mendonca]

My input data that come from my control parameter, change de original SQL in my input data:

Example:  - original sql: select * from "collection 01"  @Raj 

changes the part "collection 01" for each  parameter :