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

[wesley18mendonca_]

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]

@wesley18mendonca_ 
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.

[wesley18mendonca_]

Thank you, @Raj .

It worked very well!

[wesley18mendonca_]

@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]

@wesley18mendonca_ 
do you have parameter in query for input field?

[wesley18mendonca_]

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 :