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?
