Split and Aggregate on Comma Separated Values

h_mohayeji92

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.

Thomas_Ott

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