Skip to main content
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

 

 

 
Hi Jubert,

 

 

You can set the value of "category" as destination feature type name (i.e. output CSV file name) in the CSV writer feature type properties.

 

 

 

Takashi
Thanks Takashi! you are always as helpful... im going to try to split the 15million points problem I am having as I couldnt still figureout how to do it...whether i am using PointonAreaOverlay or Spatial Filter method it just takes too much time...

 

 

previous problem:

 

 https://knowledge.safe.com/CommunityAnswers?id=906a0000000dDva

 

 

thanks so much for your help Takashi

 

 
Link of the previous problem here:

 

https://knowledge.safe.com/CommunityAnswers?id=906a0000000dDva

Reply