Skip to main content
  • EN

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

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

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

 

 

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

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

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.