We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to segregate data into multiple sheets in same workbook

Anjankumar2021
8 - Asteroid
‎05-12-2025 08:27 PM

Hi Team, @binuacs 

 

could someone assist on the below?

 

i want to divide entire data into multiple sheets based on distributor ID. each sheet should contain unique Distributor ID.

 

for example distributor ID 179811233 - 3 line items in the input file, so it should be in 3 sheets(sheet1,Sheet2, sheet3).

 

Input  
   
ActivityDistributor IDSale Qty
Sale1798112333000
Sale1798112333000
Sale17981123312000
Sale182263485229000
Sale18273573869000
Sale18407310422000
Sale184568676101000
Sale1854819297000
Sale1858097223000
Sale1858097231000
Sale18580989033000
Sale1858099173000
Sale1858099206000
Sale1858100131000
Sale18595837063000
Sale18595840713000
Sale1859584101000
Sale18595841069000
Sale18595841222000
Sale18595842221000
Sale1859584289000
Sale18595843066000
Sale1859584521000
Sale1859584577000
Sale1859584669000
Sale1859584695000
Sale1860930139000
Sale1860930262000
Sale1860930371000
Sale1860931271000
Sale1861258055000
Sale1861258372000
Sale1861258787000
Sale18612590012000

 

Required output:

 

Sheet1   Sheet2   Sheet3  
ActivityDistributor IDSale Qty ActivityDistributor IDSale Qty ActivityDistributor IDSale Qty
Sale1798112333000 Sale1798112333000 Sale17981123312000
Sale182263485229000 Sale18595841069000    
Sale182263485229000        
Sale18273573869000        
Sale18407310422000        
Sale184568676101000        
Sale1854819297000        
Sale1858097223000        
Sale1858097231000        
Sale18580989033000        
Sale1858099173000        
Sale1858099206000        
Sale1858100131000        
Sale18595837063000        
Sale18595840713000        
Sale1859584101000        
Sale18595841222000        
Sale18595842221000        
Sale1859584289000        
Sale18595843066000        
Sale1859584521000        
Sale1859584577000        
Sale1859584669000        
Sale1859584695000        
Sale1860930139000        
Sale1860930262000        
Sale1860930371000        
Sale1860931271000        
Sale1861258055000        
Sale1861258372000        
Sale1861258787000        
Sale18612590012000        
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris
‎05-12-2025 09:08 PM

@Anjankumar2021 

A Tile will do exactly what you need here.

0513-Anjankumar2021.png

0513-Anjankumar2021.yxzp
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All