Skip to content
Advertisement

BigQuery SQL: How to find missing Values on comparing two tables over date range?

Have got two Bigquery tables as shown below:

Table 1:

Table 2:

Scenario: Have to find missing Stores of Table 1 for each date comparing with Table 2 Stores.

Expected Output: To list each missing Stores for each date on comparing.

Tried Query: But this query doesn’t shows up the respective Report_Date, instead it shows ‘null’.

Advertisement

Answer

Using a calendar table approach:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement