Hello -- need help on creating a weekly increment for an app.
The idea is to create a key based on a combination of 3 fields from original load and save that in a qvd file. Then the next week reload that data again and add '+1' if the combination stays the same. If the previous combo is not loaded in, then dropped from new stored qvd file for this week. If new, added as one to the qvd this week.
Example:
Week1:
NAME | COLOR | NUMBER |
Erica | Purple | 5 |
Mitch | Blue | 20 |
William | Green | 7 |
.. combos would be (Erica|Purple|5), (Mitch|Blue|7), etc.
Week2:
NAME | COLOR | NUMBER |
Erica | Purple | 5 |
Mitch | Blue | 6 |
William | Green | 7 |
Grace | Yellow | 21 |
** only two of the week2 combinations are constant
Counts on the sheet for Week2 should show:
COMBO | COUNT |
(Erica|Purple|5) | 2 |
(William|Green|7) | 2 |
(Mitch|Blue|6) | 1 |
(Grace|Yellow|21) | 1 |
The first "Mitch" record has been dropped and the new added to start at count of 1 again.
I currently am trying a concatenate on saved qvd files, but having issues on adding the combo where it already exists. IS there a better way to do this?