When field value depends on the row below it
Posted by: James Smith
Date: June 28, 2017 01:52AM

I need to port my company's excel records into a database.
There's a few columns that goes like this

Col1, Col2, Col3
a, b, cb
a, c, c

Col1 and Col2 are raw inputs, while Col3 has a formula like `=IF(A2=A3, C3&B2, B2)`.
The data is sorted by Col1. How can i go about structuring this in a MySQL database?

Options: ReplyQuote


Subject
Written By
Posted
When field value depends on the row below it
June 28, 2017 01:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.