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?