Create Increment on Matching Fields

esuper21 — Tue, 29 Oct 2019 12:49:50 GMT

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?

topic Create Increment on Matching Fields in Integration, Extension & APIs

Create Increment on Matching Fields