Split and Aggregate on Comma Separated Values
h_mohayeji92
New Altair Community Member
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.
Tagged:
0
Best Answer
-
@h_mohayeji92 check out the Transpose or Pivot operator, that might do what you need to do.
2
Answers
-
@h_mohayeji92 check out the Transpose or Pivot operator, that might do what you need to do.
2 -
Thank you! The De-Pivot attribute solved my problem.
1 -
@h_mohayeji92 Awesome, good luck!
0