Output to a specific range in Excel

I have following data in Alteryx

data	Amount
A	10
A	20
A	50
B	10
B	40

Expected Output : is to create 2 files with name A and B ( Each file should has two sources in the same sheet)

Files names should be created based on data columns

I have tried only this solution with block until done : https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-to-a-specific-range-in-Excel/td-p/383011

Expected out files has been attached

A.xlsx

B.xlsx

Data Investigation

Accepted answers

ScottLewis

Here's a workflow that does what I think you're getting at. Creates the total, adds the datetime and writes the total and the individual rows to each file.

You'll need to update your base filepath (with a \ at the end) in the second text input tool.

Without seeing what you tried, I suspect you were getting tripped up on the filepath string construction as it is super picky.

MultipleRangeOutput.yxmd

All comments

aatalai

@BRRLL99 take a look at the attached workflow, it should help and let me know how you get on

Output to a specific range in Excel.yxmd

ScottLewis

Here's a workflow that does what I think you're getting at. Creates the total, adds the datetime and writes the total and the individual rows to each file.

You'll need to update your base filepath (with a \ at the end) in the second text input tool.

Without seeing what you tried, I suspect you were getting tripped up on the filepath string construction as it is super picky.

MultipleRangeOutput.yxmd

BRRLL99

@ScottLewis Thank you

Tried different approach, able to get expected result.

is there any special reason you used block until done at the last for each output tool??

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335