help me out to convert my workflow into macro, which should have connect in db, data stream out, and calgary loader as output,I want both input and output anchor in my macro
What's your problem? This is a batch macro -> without seeing your action tool this may be configured correctly. I can't tell unless you describe what you are changing/what you are passing in ---> and you show the config of your action tool. Re: the output ---> how do you determine the file name? Can you use a formula tool before your calgary output to determine it?
you mentioned having a macro input and macro output ---> why? I don't see the need for either with your macro. Macro input would take an entire datastream in for each iteration. macro output would output your datastream to your main workflow.