Region wise excel files but in same folder

[BRRLL99]

I have dataset based on region

I'm looking for region wise separate files in excel. But it should be in same folder

DATA	REGION
A	NORTH
A	NORTH
B	SOUTH
B	SOUTH
C	WEST
C	WEST

Files names should be NORTH.excel file etc;

[DawnDuong]

hi @BRRLL99 

Have you looked at Output tool with the option to output multiple files and change the file names?

---

@BRRLL99 wrote:

I have dataset based on region

I'm looking for region wise separate files in excel. But it should be in same folder

DATA	REGION
A	NORTH
A	NORTH
B	SOUTH
B	SOUTH
C	WEST
C	WEST

Files names should be NORTH.excel file etc;

---

Using this method, all the output files will be in the same folder.

Dawn.

[DataNath · Accepted solution]

Hey @BRRLL99 the usual approach for splitting your dataset into different files based on field values is to create a custom filepath in a formula tool and feed that into your output data tool. I built a macro to take away a bit of the manual hassle involved: https://community.alteryx.com/t5/Community-Gallery/Output-to-multiple-Excel-files-or-sheets/ta-p/951...

In your case, as you want your [Region] to be a prefix, I've just made a [FileName] field like so:

Then just use that as the grouping field within the macro configuration:

The outputs: