ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

I want to create output based on the column name

Sshasnk
8 - Asteroid

I have a dataset, for example below

 

Dataset 1:

 

accountname
12Alex
12Alex
33Alex
43Tom
2Tom

 

So based on the name column I have to create 2 files one where all the Alex is data is and another for Tom,

Output Alex.xlsx and Tom.xlsx

 

Note: The catch is there could be n number of names So I cant just put 2 output tool I have to group by and somehow create it

1 REPLY 1
binu_acs
21 - Polaris

@Sshasnk One way of doing this

binuacs_0-1676889401958.png

 

Labels
Top Solution Authors