Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dashboard where I'm loading a data structure like this:
Region_ID | Value | Month | Product |
ABC | 348750 | 201402 | Fixed Net |
ABC | 467556 | 201402 | Mobile |
So I have two rows in the database per Region and month, one for each product. The problem is now, that for some
Regions, there is only one Product available (let's say Mobile) and the other entry does not exist.
How can I create a dummy entry for those missing Product rows to always have two entries per Region and Month, e.g.:
Region_ID | Value | Month | Product |
DEF | 0 (Dummy entry) | 201402 | Fixed Net |
DEF | 45545 | 201402 | Mobile |
Thanks,
Jens
Thanks, but this is not necessary, I guess.
The Team_Id is always the same for a specific region
Region_ID, Value, Month, Product, Team_ID
ABC, 348750, 201402, Fixed Net, 1
ABC, 467556, 201402, Mobile, 1
DEF, 45545, 201402, Fixed Net, 2
So for the missing Mobile row of DEF, the team_id needs to be 2, too.