Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
veryimportantdude
Contributor III
Contributor III

Row manipulation based on previous row

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

Labels (2)
1 Reply
Anonymous
Not applicable

Hi

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

 

Regards

Shong