Have separate output file

Screenshot_20231117_131228_Microsoft 365 (Office).jpg

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

Best Practices

Accepted answers

Qiu

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

1117-ardbramantyo.yxzp

All comments

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

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

1117-ardbramantyo.yxzp

ardbramantyo

Thanks

ardbramantyo

Why I also have .bak file in my output?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703