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: Codereport123a555f123b123a555a555w897e897r123c555a897b I want to make an output that looks like Codereport123a123b123a123c Codereport555f555a555w555a Codereport897e897r897b I hope this makes sense, to have separate files that have the common code. Thanks any help is appreciated.

split data with same codes

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.

Datasets

Preparation

Accepted answers

JosephSerpis

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.

Output_06122021.yxmd

Christina_H

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.

All comments

JosephSerpis

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.

Output_06122021.yxmd

Christina_H

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:

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)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703