InfoSet Delemma

[former_member260745]

Hi All,

I have created an InfoSet using Position to Employee using Position # to join both IOs. Employee is set to Left outer join. Position is my driving IO.

My requirement is to user Filter Position # and Key Date and return everything from Position even if there is no matching from EMP and matching values from Employee. (I think, this is how left outer join suppose to work)

BUT when I filter by Position 30000000, Key Date 6/14/2014, I am not getting any value.  Am I missing something.

POSITION:

Position	Valid to	Valid from	Job	ORG
30000000	6/30/2005	01/01/1000
30000000	12/10/2005	7/1/2005	20000000	10000000
30000000	6/30/2007	12/11/2005	20000000	10000302
30000000	8/27/2007	7/1/2007	20000000	10000302
30000000	6/30/2008	8/28/2007	20000000	10000302
30000000	6/30/2010	7/1/2008	20000000	10000302
30000000	6/30/2011	7/1/2010	20000000	10000302
30000000	12/31/9999	7/1/2011	20000000	10000302
EMPLOYEE:
EMP #	Valid To	Valid From	Position	Job	Org
12360000	4/10/1949	01/01/1000
12360000	12/4/2005	4/11/1949
12360000	12/10/2005	12/5/2005	30000000	20000000	10000000
12360000	2/23/2006	12/11/2005	30000000	20000000	10000302
12360000	6/30/2006	2/24/2006	30000000	20000000	10000302
12360000	1/8/2007	7/1/2006	30000000	20000000	10000302
12360000	1/20/2007	1/9/2007	30000000	20000000	10000302
12360000	3/4/2007	1/21/2007	30000000	20000000	10000302
12360000	6/30/2010	3/5/2007	30000000	20000000	10000302
12360000	10/17/2010	7/1/2010	30000000	20000000	10000302
12360414	6/30/2011	10/18/2010	30000000	20000000	10000302
12360414	6/30/2012	7/1/2011	30000000	20000000	10000302
12360414	6/13/2014	7/1/2012	30000000	20000000	10000302
12360414	12/31/9999	6/14/2014	99999999	20000000	10000302

Thanks

AKA

[sriramvijay_ravidoss · Accepted solution]

Hi,

Do you have records in EMPLOYEE for the combination 6/14/2014 and 30000000. Because in the given records in your questions. it is not there.

You should have records in EMPLOYEE first, to show data for a left outer join.

-Sriram

[Former Member]

Dear Arjun,

In your case, you should make position left outer join to bring the all data from position irrespective of employee data.

Regards,

Ashish