i want to output to multiple new sheets in one excel file.
the sheets don’t exist. so i would be writing to a newly created sheet. i want the name of the sheet to be the value in a field.
for example, if i had [cities] with 50 unique values and each city had other related data, then i want one file that had 50 tabs where each tab was a city name and the contents of each tab would be the related data.
i understand that i can have variable file names. but can i have variable sheet names that come from field names? what would be the best way to do this?
i think that the thing i wasn’t sure about was what would happen when you have an output column with the same value. and after your reply and a quick test, i understand that the “write mode” of “overwrite” won’t overwrite previous rows.
within a run, it appends (each row), and
between runs (when overwrite is chosen), it overwrites .