Row manipulation based on previous row

veryimportantdude — Wed, 11 Aug 2021 11:38:06 GMT

Hello,

I have the following problem.

I would like to manipulate data so that when rows are joined all rows are written to excel file, but only for the first row (based on the key cell) has values. To explain better

Product_ID;Inventory; sellUnits;

AAB;10;4;

AAB;0;3

AAB;0;2

CCA;15;4

CCA;0;3

DDA;1;1

My thinking is in kind of ways to sort data from excel, and then use some kind of when Product_ID changes, write inventory = 0.

ANy suggestion how to achieve this would be helpfull.

Thank you

Re: Row manipulation based on previous row

Anonymous — Fri, 13 Aug 2021 05:44:14 GMT

What is your expected output? Maybe tMemorizeRow component fit your need?

Regards

Shong

topic Row manipulation based on previous row in Talend Studio

Row manipulation based on previous row

Re: Row manipulation based on previous row