Forum Discussion
Transform table with maximum quantity of 100 per week
could you please give the result table you are after?
Another important aspect: should be the date column be sorted, before eatablish wich row has to be splitted?
Hi Anonymous
I'm looking for the outcome table as such.
For the date column, not necessarily sorted, as long as the order and structure of the row/date/order-ID is maintained.
Is not completely clear to me the role of order id and what you mean
with this sentence: "as long as the order and structure of the row/date/order-ID is maintained".
If you don'thave sorted date and don't specify wich row you should move from actual week to the nex week (ween you have a surplus, as for week 2, you have many possibilities to chose. Which one is the rigth one?)
I'm afraid that the structure will not be maintained: wich id shoul have the yellow record of week 3?
Could you post a table with IDs too?- danextian
Super User
Anonymous ,
My thoughts too. Which order id's quantity should be carried over and which order id in the next week this will be added to? There are no order id's in the sample provided.
