Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Divide data in table as separate tables based on a unique id

SahadhKuruniyan
8 - Asteroid

Hi Team,

 

I am working on a project. I am a beginner. Can anyone help me with my query below:

 

I have a excel tab which as a list(See tab "Current output" in attached file). now I want to split this table as  separate tables in a single tab (want tables in single tab as output) based on a unique number in coloumn A.

 

Can any one please help. this would be biggest help :)

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@SahadhKuruniyan 
This can be done by providing a fulll path for the output including the Tab name

0515-SahadhKuruniyan.PNG

binuacs
21 - Polaris

@SahadhKuruniyan Based on my understanding I think you are looking for the column in same tab, in that case you can use the Table tool to group the fields based on the unique number.

 

 

binuacs_0-1652598907494.png

 

binuacs
21 - Polaris

@SahadhKuruniyan Another way of doing this with the batch macro

 

binuacs_0-1652622117495.png

 

grazitti_sapna
17 - Castor

@SahadhKuruniyan, as @binuacs suggested this can be achieved using reporting tools. Below is the configuration that I used along with the output.

 

grazitti_sapna_0-1652680773769.png

grazitti_sapna_1-1652680812453.png

 

You can change the output mode as per your requirement.

 

Thanks!

 

 

 

Sapna Gupta
Labels
Top Solution Authors