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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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