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

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.

tce2.png

tce3.png

tce1.png

tce4.png

Batch Macro

MongoDB

Iterative Macro

Accepted answers

Raj

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

Batch Macro.yxmc

All comments

Raj

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