split data with same codes

[MZ900605]

hello guys, I need help in using Alteryx to split the data with the same codes, maybe the tool exists or I should do a macro.

the data is 10K rows looks like:

Code	report
123	a
555	f
123	b
123	a
555	a
555	w
897	e
897	r
123	c
555	a
897	b

I want to make an output that looks like

Code	report
123	a
123	b
123	a
123	c

Code	report
555	f
555	a
555	w
555	a

Code	report
897	e
897	r
897	b

 I hope this makes sense, to have separate files that have the common code.

Thanks any help is appreciated.

[JosephSerpis · Accepted solution]

Hi @MZ900605 you can do this with the output tool and using the option Take/file/table from field which is your case would be the code column. I mocked up how you can do this.

[Christina_H · Accepted solution]

A lot of the tools in Alteryx have a grouping option for this type of thing.  Assuming you just want to output the above tables, something like this would work:

Note at the bottom I've checked the option to "Take File/Table Name From Field".  With the option I've select (Change File/Table Name) this should output to a single Excel file with a tab for each code.

[MZ900605]

@Christina_H am doing it and it keep writing the error (You must specify sheet name.) am choosing to create new sheet, even wrote sheet name when adding the output tool.

[MZ900605]

@JosephSerpis I changed to my file path but its not outputting anything

[Christina_H]

@MZ900605 If you're copying mine exactly, I'd missed out a \ in the path, it should be .\Filename.xlsx|||Sheetname

You can also enter an absolute path rather than relative, or generate the correct filepath for each row in a formula tool and use that for grouping with the option "Change Entire File Path" (remember to include the sheet name for Excel though)