Left Outer Join doesn't seem to be working in Infoset

[former_member238607]

Hi,

I'm trying to create an Infoset that joins a DSO containing weather information (daily high and low) with a second DSO containing meter reads. The weather DSO contains data for every day of the year. The meter read DSO contains data for some days of the year.

I want the Infoset to return one record for each day in the selected date range, regardless of if the meter was read that day. I'm testing in Dev using an older date range of 05/01/2016 - 05/31/2016. When I select my test meter for this date range, I'm expecting 31 records (one for each day in May), but instead I'm only getting four records (one for each day the meter was read in May 2016).

This is the design of my Infoset:

These are the results I'm getting:

Can anyone tell me what I've done wrong and how to correct this issue?

Thanks for your help!

[former_member238607]

Hi Ricardo,

I had already tried switching the DSOs. No matter which one is on the left, I still get the same results. The Weather DSO contains the 31 records I'm looking for, so based on my understanding of a left join, that DSO should be on the left side.

You also mention making that DSO the "main DSO". Is there an actual setting in an Infoset to for that? I looked around, but I did not see a way to specify the main data source. If there is a way, that is probably what I need to do. But again, I don't see a way to do that.

Thanks for your help!

[Former Member]

Hello;

Use the DSO that contains the 31 records for May as the main DSO, link it (left outer join) with the other.

I think you need to swap your order.

Hope it helps;

Regards