Output Multiplesheets within Excel

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

Data Investigation

Accepted answers

binu_acs

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

WriteToMulti_Sheets_04032024.yxmd

All comments

binu_acs

@BRRLL99 One way of doing this

WriteToMulti_Sheets_04032024.yxmd

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

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

WriteToMulti_Sheets_04032024.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703