The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Split and Aggregate on Comma Separated Values

h_mohayeji92h_mohayeji92 Member Posts: 2 Learner III
edited December 2018 in Help

I have a column in my example set which contains comma separated hashtags. I want to first split these hashtags and then perform an aggregation on them, for example counting frequently used hashtags.

Right now I'm using Split operator, but the result of this operator is something like hashtags_1, hashtags_2, hashtags_3 and etc, and I don't know how to do an aggregation on all of these columns.

Any help would be greatly appreciated. Thanks.

Best Answer

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn
    Solution Accepted

    @h_mohayeji92 check out the Transpose or Pivot operator, that might do what you need to do. 

Answers

Sign In or Register to comment.