Discussion Board for collaboration on QlikView Scripting.
I'm having some trouble trying to solve this issue:
I have the vendor table with these fields:
And the periods table with these fields:
What I need to to is create records for each vendor, starting from the first period available until the last registered.
That would generate this for vendor 01, for example:
Each period is 6months large.
Using what you suggested and some other stuff I looked into qlikview documentation, I figured out the solution.
Hope it can help you with similar issues o/
View solution in original post
I think IntervalMatch may be what you're looking for
It will be helpful...
Below script may help you ...
LOAD * INLINE [CODE_VENDOR, DATE_ADM01, 26/06/201302, 10/09/201303, 15/10/201304, 20/10/201305, 19/11/2013];Period:LOAD * Inline [Period_Start, Period_End 25/06/2013, 20/12/2013 24/07/2013, 23/01/2014 24/08/2013, 23/02/2014 25/09/2013, 24/03/2014 24/10/2013, 22/04/2014 26/11/2013, 25/05/2014 21/12/2013, 19/06/2014 24/01/2014, 23/07/2014 ];IntervalMatch(DATE_ADM)LOAD Period_Start, Period_EndResident Period;