Hello, Is there a way i could replace a row value to its previous row by each group. Below is the before and after dataset. Product for each type - C needs to be changed as type- L for each customer when the ID is same it has the highest amount. Before: Customer ID Type Product Amount 1 12432 L A 234 1 12432 C B - 2 23213 L C 23,212 2 23145 L D 335 2 23145 C E - 3 21311 L F 323 3 21324 L G 2,344 3 21324 L H 34 3 21324 C I - After: Customer LINK_ID Type Product Amount 1 12432 L A 234 1 12432 C A - 2 23213 L C 23,212 2 23145 L D 335 2 23145 C D - 3 21311 L F 323 3 21324 L G 2,344 3 21324 L H 34 3 21324 C G - Thank you!
... View more