I need help with something that I have not been able to achieve (I am a beginner), I have a series of data that is entered daily, 4 of them are the same and the only thing that changes is a weight that is entered one by one, then the following group of data and once again 4 values are repeated.
What I need is that in the first data record of the day the 5 different values are entered; with the first 4 data that are repeated an alphanumeric key is created (I did it with CONCATENATE), and this alphanumeric key will be my PARENT, then I need all the CHILD records to be entered one by one, while my PARENT (alphanumeric key) is repeated , until the next set of data arrives.
I hope I explained myself correctly, I would appreciate the help!
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |