community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Split rows into different sheets

Meteor
Hey

I have an excel sheet which has 5,00,000 rows and there are about 40 columns. Now, i want to spilt data on the basis of values in one column

This column has 375 unique values. The output should be 375 tabs and each tab about contain all the records of each unique value appearing the dataset.

Does anyone know of a way to solve this problem? Would be of great help
Alteryx
Alteryx

Hello,

use the option of the output tool to take file/table name from field and choose your column.

If it works for you don't forget to approve as a solution.

Thanks.

 

Capture.JPG

Labels