Cardinality : Populate missing/non-existent elements

General
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.

1 REPLY
Enthusiast

Re: Cardinality : Populate missing/non-existent elements

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