Dates Issue

dseelam · ‎2014-01-19

Last try simple way

DATA MODEL

I have 2 tables one with fields- Primary key SID, warrstart, warr end end and other table with con start, con end

Condition:

Warr end was limited to current fiscal year 2013

Issue:

Duplicates issue after resident load of max warr end and min constart

Example- when I join 2 tables

There are 3 same sids with warrstart, warrend dates following constart, conend dates for diff con_types

Requirement?

-Show me only max warend and a following min contract start date and there corresponding records for each sid and dont show other records

Testing:

When I try to test only one table for max warr start date then also I am getting duplicates

Example

In this case its picking max warr end but also all warr start dates which is not right it should be corresponding date for for max warr start date

I am using resident loads for max warr end and min con start for each table

Please help .................

Thanks in advance

swuehl · ‎2014-01-19

I think it would be easier if you post your input data (or a sample / mock up of the data), and your requested results made out of the input.

dseelam · ‎2014-01-19

Hello Swuehl

I attached a Sample QVW check it out

Output should be 1st criteria MAX WARR END DATE following MIN CONTRACT START DATE and corresponding dates

not supposed to get any duplicates but in the sample u can see some duplicates

Results expecting

Related Topics