Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulhv1
Creator II
Creator II

How to genarate records in range

Hi Everyone!!!

I ave following records.

Emp no.  name     start_date    end_date    grade

1              rhv         01-Jan-10   31-Mar-10   M1

1              rhv         01-Apr-10   30-Apr-10    M2

1              rhv         01-May-10   31-Dec-10   M3

2              abc        01-Mar-10   31-May-10   M1

2              abc        01-Jun-10   30-Jun-10   M2

I want to generate records for each month from above range of start date & end date  i.e.

Emp no.  name     start_date    end_date    grade   INTERMIDATEMONTH

1              rhv         01-Jan-10   31-Mar-10   M1       JAN-2010

1              rhv         01-Jan-10   31-Mar-10   M1       FEB-2010

1              rhv         01-Jan-10   31-Mar-10   M1       MAR-2010

1              rhv         01-Apr-10   30-Apr-10    M2       APR-2010

1              rhv         01-May-10   31-Dec-10   M3      MAY-2010

1              rhv         01-May-10   31-Dec-10   M3      JUN-2010

1              rhv         01-May-10   31-Dec-10   M3      JUL-2010

1              rhv         01-May-10   31-Dec-10   M3      AUG-2010

1              rhv         01-May-10   31-Dec-10   M3      SEP-2010

1              rhv         01-May-10   31-Dec-10   M3      OCT-2010

1              rhv         01-May-10   31-Dec-10   M3       NOV-2010

1              rhv         01-May-10   31-Dec-10   M3       DEC-2010

2              abc        01-Mar-10   31-May-10   M1        MAR2010

2              abc        01-Mar-10   31-May-10   M1        APR2010

2              abc        01-Mar-10   31-May-10   M1        MAY2010

2              abc        01-Jun-10   30-Jun-10   M2          JUN2010

0 Replies