Skip to Content

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

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!

infoset1.png (27.8 kB)
infoset2.png (10.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 10, 2017 at 06:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 11:54 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded