Skip to main content
Question

Add features based on attribute value of existing features

  • November 28, 2017
  • 4 replies
  • 110 views

Forum|alt.badge.img

Hi there,

I have an existing spreadsheet and need to add in rows of information from a different spreadsheet based on the column value from the existing spreadsheet. I need to then write this to Excel again.

Any suggestions?

Thanks

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.

4 replies

david_r
Celebrity
  • November 28, 2017

Sounds like you should have a look at the FeatureMerger transformer.


Forum|alt.badge.img
  • Author
  • November 28, 2017

Sounds like you should have a look at the FeatureMerger transformer.

Thanks David, I don't actually need to merge the attributes, I just need to order and duplicate the features based on the attribute value from the existing spreadsheet

 

 


david_r
Celebrity
  • November 28, 2017

Could you post some sample data here as well as the expected result?


Forum|alt.badge.img
  • May 28, 2019
Thanks David, I don't actually need to merge the attributes, I just need to order and duplicate the features based on the attribute value from the existing spreadsheet

 

 

I'm going to try this suggestion of using the "Cloner" transformer based on a Tester: https://knowledge.safe.com/questions/5076/how-to-duplicate-features-based-on-an-attribute.html