Skip to main content
Solved

Flatten File


Forum|alt.badge.img

I've got output from 3 statscalculators coming together to create the following and was wondering how I could 'flatten' it such that that one record exists for each community and <missing> values have a value of zero.

So the output would look like the excel image.

Best answer by takashi

Hi @aviveiro, the Aggregator (Group By: COMMUNITY, Accumulation Mode: Merge Incoming Attributes) might help you. Then, to assign zero to missing attributes, consider using the NullAttributeMapper.

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

2 replies

takashi
Influencer
  • Best Answer
  • March 9, 2018

Hi @aviveiro, the Aggregator (Group By: COMMUNITY, Accumulation Mode: Merge Incoming Attributes) might help you. Then, to assign zero to missing attributes, consider using the NullAttributeMapper.


Forum|alt.badge.img
  • Author
  • March 10, 2018

Terrific @takashi !

Your suggestions worked.

Thank you.


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