How to generate multiple output files using iterative macro

[chinnaupendra07]

by using iterative macro generate the multiple files output for each entity code for using csv format

[DataNath]

Hey @chinnaupendra07, is there any reason this needs to be an iterative macro? Perhaps you could provide more detail and some sample data etc if so.

If you're just wanting to create multiple files based upon a field in your data (like Entity Code), then you can do so in the Output Data tool. Here's a very simple example. Data:

Output Data configuration - ticking 'Take File/Table Name From Field'. There's a few examples here, for this scenario I've just added the Entity Code to the end of the FileName with 'Append Suffix to File/Table Name':

Running the workflow now gives an output file for each, splitting them on Entity Code: