Solved

Split the table multiple tables

Forum|Forum|10 years ago
September 25, 2015
3 replies
77 views

jubert

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

Best answer by takashi

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

takashi
Best Answer
Forum|Forum|10 years ago
September 25, 2015

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

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Upvote

J

jubert
Author
Forum|Forum|10 years ago
September 25, 2015

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