Have separate output file

[ardbramantyo]

 hi, i have this dataset and I want to have several excel file as output with filename is the campaign name. In the output file I want to have 3 worksheet. Sheet one for overall data, sheet 2 for list thay have value SMS from flag column and one sheet called WA for overall list that have WA value in the flag column. In my original dataset I have total of 12 campaign name so I will have 12 excel files at the end and for every file I will have e worksheets. For overall, WA, and SMS sheet

 

[gawa]

@ardbramantyo 

You can use option of Output tool "Take File/Filed Name From Field" to create separate outputs,

For example, you can create file path by Formula tool like this. Please specify sheet name after "|||".

[ardbramantyo]

What if I want to have 3 worksheet in my every generated files that taken from my Flag column? I want to have WA sheet and SMS sheet based on criteria

[Qiu · Accepted solution]

@ardbramantyo 
I think we may need to a Batch Macro for this task.
For each Campaign code, we will process your requirement in the macro.

[ardbramantyo]

Thanks :)

[ardbramantyo]

Why I also have .bak file in my output?