Options

Split and Aggregate on Comma Separated Values

h_mohayeji92h_mohayeji92 Member Posts: 2 Contributor I
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

  • Options
    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

  • Options
    h_mohayeji92h_mohayeji92 Member Posts: 2 Contributor I

    Thank you! The De-Pivot attribute solved my problem.

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

    @h_mohayeji92 Awesome, good luck!

Sign In or Register to comment.