Split rows into different sheets

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

Transformation

Dynamic Processing

Data Investigation

Accepted answers

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.

All comments

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.

I tried this but keep getting an error that says "You must specify a sheet name". How do I do that?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703