Skip to main content
Solved

Append Comma Separated values of One Column


Forum|alt.badge.img

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!

Best answer by ebygomm

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

comma_split.fmwt

View original
Did this help you find an answer to your question?

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

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.


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • Best Answer
  • May 21, 2019

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

comma_split.fmwt


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings