Skip to main content
  • EN

Hi,

This might be simple but a tricky one for me. Also, I had read a lot about transposing data from rows to columns and vice versa, etc., but couldn't find much about this one.

I have data in one column which are column separated.

1,2,3

 

2,3,6

 

4,6

 

I want to append all the data one below the other and take the count of which number appeared how many times. I can take the count from Aggregator.

1

 

2

 

3

 

2

 

3

 

6

 

4

 

6

 

 

Approach that I followed: AttributeSplitter(list 0-100(since the values can be too many as well)) to disintegrate the values in different columns. But, that leads to a number of columns and appending all the columns and rows in one column becomes the issue.

Any quick solution for this? Thanks!

AttributeSplitter to turn it into a list, then ListExploder to turn them into individual features and an Aggregator, grouping by that value, to get the counts should do the trick.

The attribute splitter followed by a list exploder should produce the output you want

comma_split.fmwt

Reply


Community Stats

30,162
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.