Hi,I am looking to display some columns a Sheet1 of an excel file and some other columns in Sheet2. Is there any way of defining which fields appear in a specific sheet?Thanks,Jess
Here is a sample workflow. I added a block until done to help prevent excel write issues.
@murrayjl03,
If you use a select tool to bring the columns to the specific sheet, then you can use two output tools to create the sheets. You can get fancy and use a single output tool, but to keep it simple just try that.
Cheers,
Mark
Great thanks! Once i have the 2 outputs for my 2 sheets how can i get these in the same excel workbook?
If you configure each of the output files to write to: My Output.xlsx
And give each a unique name: Sheet 1 & Sheet 2
(also configure to overwrite sheet/drop)
That's how you can write twice to the same filename.
