Output to same file but multiple sheets

[sergiogarciagt]

Hi,

I have a file that has duplicated account numbers therefore I want to create an excel file with two sheets, one with all the accounts and one sheet just showing up the duplicated values. I have the unique tool as my last tool and I have connected two outputs to the tool these to outputs are going to the same file, however it is not allowing me to add the sheet to the file.

Any suggestions, or is this even possible to be done?

Thanks!

SG

[terry10 · Accepted solution]

All you need to do is append an explicit sheet name to your output destination using |||

e.g.,

filename.xlsx|||Uniques

filename.xlsx|||Duplicates