KQL - Adding a row for each combination of two rows

Matthew House 0 Reputation points Microsoft Employee
2023-01-24T20:42:57.74+00:00

I have two tables:

  • Table 1: ID, blah blah blah blah
  • Table 2: Dates

There are a total of 12 dates in Table 2. I want to create a new table where the ID from Table 1 is matched with EACH date from Table 2. Basically, for each ID, there will be 12 rows in the new table. I can't join since there are no matching values between the tables and I tried a union, but I'm unsure how to accomplish what I'm asking.

User's image

User's image

User's image

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
Community Center | Not monitored
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.