Output Multiplesheets within Excel

[BRRLL99]

Hi Team,

I have two data set,

I'm looking for expected out as Single excel file, as Funds_March_2024 ( march 2024 needs to be dynamic as per month and year), within that file i need to have 4 sheets

sheet names as

A  sheet (contain dataset-1 A rows only)

 B(contain dataset-1 B rows only),

C(contain dataset-1 C rows only)

Summary ( entire dataset -2)

I tried using block until done but not getting the expected output.

dataset-1

SL NO	DATA
1	A
2	A
3	B
4	B
5	C
6	C

Dataset -2 ( created using summarize tools)

DATA	Summary
0-10	60
20-10	10
100-150	2

[binu_acs]

@BRRLL99 One way of doing this

[BRRLL99]

@binu_acs 

I have tried your workflow , it is creating only 2 blank files

FUNDS_MARCH_2024   type: File

FUNDS_MARCH_2024.bak         type: bak File

expected output is not getting created in excel format.

[binu_acs · Accepted solution]

@BRRLL99 update both the formula tool and add the extension .xlsx in the FullPath 

[BRRLL99]

 I have used same logic (sample logic creating 4 sheets)

but in my expected output it is giving me only one sheet unidentified
do you know the reason?

[binu_acs]

@BRRLL99 I am not sure about your data, was the workflow I sent you working as expected? Check your sheet name variable has the appropriate sheet names according to your requirement