Solved

Append Comma Separated values of One Column

Forum|Forum|6 years ago
May 21, 2019
2 replies
108 views

dewan

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+61

redgeographics
Celebrity
Forum|Forum|6 years ago
May 21, 2019

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.

FME rocks! \m/