how to combine two outputs from same workflow into excel work book

[Anjankumar2021]

after running workflow i have received two sets of data outputs

Output1 : Sheet1 

output2: sheet 1

requirement is to above sheet 1 name should change to "Customized" from output 1

and sheet 1 name shout change to "Actual data" from output 2

these two sheets should in one excel workbook (sheet1 :Customized and Sheet2:Actual data)

[dwstada]

if your column names/amount does not change, add a new column to both datasets called something like "sheetname" and add your prefered name as string. Then union both datasets and activate "Take File/Table Name From Field" in the Output tool. Here you can select that it takes the name in your newly added column as the sheet name in the excel file and it will create two sheets with the respective names.

[Anjankumar2021]

when iam adding new column "SheetName" in formula tool iam getting an error.

ErrorLink: Formula (32): Parse Error at char(0): Unknown variable "SheetName" (Expression #1)

[Anjankumar2021]

got it , issue resolved. but what if both outputs has different set columns. pls advise

[dwstada]

if columns are different then we have to use two output tools. I would still union both data streams, then use a block until done tool so we can write into the same file.

You have to deselect the columns of the other output that you don't want and then filter out all the rows that are from the other output (by using a unique column for that output)