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

Question

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 · Answer

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)

Anjankumar2021 · Answer

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

Anjankumar2021 · Answer

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)