You can combine data from two or more data streams into a single data stream using cogroup. The data streams must have at least one common field. By default, only data that exists in both groups appear in the results.
in this sample, data stream qsd contain field State and data stream qsp also contain field State, we can use it for grouping.
Account in ops data stream will have the same value as Company in meetings data stream.
Use case: show death per state percentage from 2 datasets.
Let's try to use Opportunity and User datasets from our previous blog.
If you notice, Angela is not shown on that chart, because she does not have any Opportunity records. Remember that only data that exists in both groups appear in the results.
Wait... there is more, Outer cogrouping combines groups as an outer join. For the half-matches, null rows are added. The grouping keys are taken from the input that provides the value.
Specify left, right, or full to indicate whether to perform a left outer join, a right outer join, or a full join.
Let's use the same SAQL from above and add left outer join.