Split the table multiple tables

Hi, 

 

 

Say I have a massive table (+15million lines) with multiple columns , it has a Field called "category"..the category Field has multiple data values in it.

 

 

how do i split the table based on the field category? say the field has 150 categories in it..therefore I need to have 150 tables.

 

 

so if the input is 1 csv file.. the output required is 150 csv files separated per category.

 

 

I think this could be a test filter with so many filters in it.

 

 

 

thanks in advance.

 

 

kind regards,

 

Jubert