Output to separate excel file with different tab name for respective input data

I have four containers (A1, A2, A3, A4) in a workflow and I am able to run all the container successfully. Each container (A1, A2, A3, A4) have one common field; example "City Name"

Now I want to take the output from each container in separate excel file based on “city name” and each excel file having different tab name (A1, A2, A3, A4)

For example – File name/ workbook “New York” will have four tabs /work sheet (A1, A2, A3, A4)

File name/workbook “London” will have four tabs/ work sheet (A1, A2, A3, A4)

I would really appreciate the response for the above query.

Reporting

Output

Accepted answers

Ladarthure

Hi @abhishekyx,

to do so, you can "play" with the fullpath and change it in the output, the only thing you need is to have the same columns after all your containers, here is a sample workflow.

sample_file.yxmd

All comments

Ladarthure

Hi @abhishekyx,

to do so, you can "play" with the fullpath and change it in the output, the only thing you need is to have the same columns after all your containers, here is a sample workflow.

sample_file.yxmd

saibal_78

You need to create a new field called "File Name" and mentioned the path details like "C:\users\city name.xlsx|||A1", "C:\users\city name.xlsx|||A2" and so on for each set of data against city name, then configure your output tool as shown in attachment.