How to fill missing data from an SQL source

[#1]

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

[#2]

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.