Hello, Need help with below. The data can have multiple levels so would require a Macro. ColumnAColumnBABCa1234ABCb4321a1234c4545a1234d6565b4321z1234b4321f8686c4545u8989 What I need is ABCa1234,b4321,c4545,d6565,z1234,f8686,u8989a1234c4545,d6565,u8989b4321z1234,f8686 Trying to figure how to make it in Alteryx, so far no luck. Would appreciate the help.

Macro Help

Hello,

Need help with below. The data can have multiple levels so would require a Macro.

ColumnA	ColumnB
ABC	a1234
ABC	b4321
a1234	c4545
a1234	d6565
b4321	z1234
b4321	f8686
c4545	u8989

What I need is

ABC	a1234,b4321,c4545,d6565,z1234,f8686,u8989
a1234	c4545,d6565,u8989
b4321	z1234,f8686

Trying to figure how to make it in Alteryx, so far no luck.

Would appreciate the help.

Datasets

Macros

Iterative Macro

Accepted answers

T_Willins

@maverick_70,

The attached workflow should work for what you are looking for. This is a variant of an iterative macro I use to create trial balance validations.

Iterative Macro

Workflow

Parent Child Workflow.yxzp

All comments

DannyS

Hi @maverick_70 ,

It appears that you are trying to aggregate that dataset, but what is not apparent is the pattern the pattern in which you need to group the data by. My initial thought would be to use a summarize tool to group your data by column A and the use the "concatenate" option for Column B with a comma separator:

That gets you in a slightly better state (and in turn could easily be created as a macro) but not the exact outcome you were looking for. Can you explain the outcome a bit more?

maverick_70

Say ABC is the top most level. Anything that goes into it will be part of it hence the concatenation.

and anything that goes into a1234 will be part of it.

Hope this clarifies it.

forgot about c4545. the result for it will look like c4545=u8989

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703