Analytics
Enthusiast

## Cardinality : Populate missing/non-existent elements

Hi,
I would like you to see teh example below and share your thoughts on the approach or solution -
Table 1
consumer, dept,frequency,recency
12345, a, 20 , 100 days
22345, a, 22 , 100 days
32345, a, 20 , 101 days

42345, a, 20 , 100 days
52345, a, 0 , 100 days
62345, a, 0 , 200 days
that gives us -
Frequency Candinality: [0-22]
Recency Candinality: [100-200]
I want to populate the last two combinations for all the customers i.e. mock up rows for non-existent combinations and fill all the points in teh cardinality.
Table 2

a, 20,100, 2
a, 22,100, 1
a, 20,101, 1
a, 0,100, 1
a, 0,200, 1
a, 0,101, 0
a, 0,102, 0

can you suggest an approach or a solution ? ofcourse I'm okay if I'm unable to calculate this while populating teh table and append it later or have it in a separate table.

thanks.
Suyog.
Tags (1)
2 REPLIES 2
Enthusiast

## Re: Cardinality : Populate missing/non-existent elements

In short I want to extrapolate data values for non-existent combinations.

Enthusiast

## Re: Cardinality : Populate missing/non-existent elements

Could you please explain again what u need ? not very clear.