Solved

Append Comma Separated values of One Column


Badge

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!

icon

Best answer by ebygomm 21 May 2019, 09:02

View original

2 replies

Userlevel 5
Badge +25

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.

Userlevel 1
Badge +10

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

comma_split.fmwt

Reply