Creating 2 Sheets (with different names) in 1 outcome file (excel)

[abae]

Hello,

I was wondering if there is a way to create 1 excel outcome file, but with 2 different sheets.

As per my workflow below, I have an excel output file that is created called "Final Template Output.xlsx". It will be created in a sheet called "Actuals".

However, I was wondering if there is a way to somehow connect the 2nd data file below into this same excel output, but create it in a 2nd sheet called "Version". It has a different data info/set.

For the 2nd file, I was able to create until "select", and just have to connect to the above "Final Template Output.xlsx". 

Thank you.

[Felipe_Ribeir0]

Hi @abae 

Here (append tool), keep only F1 selected:

Here second output tool, rename the sheet to Version

[abae]

Thank you Felipe_Ribeir0,

I tried fixing the below 2 (append and output), but the outpull file now only shows 1 tab instead of the original 1st tab :(

Here is the updated workflow, as well as new output file (Test1.xlsx).

It also shows F1 and 4 different rows, instead of just 1.0 in Cell A1.. :(

[Felipe_Ribeir0]

Another thing, you must use first 1 row option, not 100

[Felipe_Ribeir0]

@abae try this version. I cannot test it here (you didnt share the input file), but it should work as expected

[abae]

Hello Felipe_Ribeir0,

thank you once again! :)

It spits out the file as 1.0, but it is still not generating 2 different sheets :(

It is still only generating 1 sheet with the file name "version".

I was hoping to have the 1st output sheet "Actual" and 2nd sheet as "version"..

[Felipe_Ribeir0]

Hi @abae 

It is because the filename needs to be the same, just the sheetname must be different