Build list attribute by compressing existing one in FME
Geographic Information Systems Asked by pfadenhw on February 25, 2021
I currently have an attribute table that is exploded – attribute A is repeated for each unique value of attribute B. But I want to "compress" attribute A and change attribute B to a list – so that the new table has only unique values of A and all of the corresponding unique values for B are complied in a comma delimited list attribute (so they’re all in the same cell).
One Answer
I think the Aggregator transformer will do what you need here. Set it up to aggregate with a Group-By on attribute A, and attribute B is the "Attribute to Concatenate"
With that you'll get a separate feature for each unique A value, with all of the B values in a comma-separated list.
I'm not sure if you wanted a real FME list, or just a plain attribute with a comma-delimited list. My version is just a plain attribute, but to get an FME style list, just check the box for Generate List.
Here's the results. I'm hoping this is what you wanted:
Correct answer by Mark Ireland on February 25, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Peter Machado on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?