Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Am am thinling about making this conversion for a source file, but i cannot find a way with a good performance for the moment.
¿Does any one know an esay way to do iit?
¡¡Thank you all!!
Hi,
You can do this with IntervalMatch functionality in QlikView.
Check the attched appalication.
Hope this helps you.
-Sridhar
Not able to understand your problem.
Can you give us some more information on your problem and post your sample data and sample O/P.
-Sridhar
Ok an example:
Mi data spource is:
| Date from: | Date To | Code |
23-03-2009 25-03-2009 F4
19-06-2009 24-06-2009 H3
And I want to convert it into:
| Date | Code |
23-03-2009 F4
24-03-2009 F4
25-03-2009 F4
19-06-2009 H3
20-06-2009 H3
21-06-2009 H3
22-06-2009 H3
23-06-2009 H3
24-06-2009 H3
Hi,
You can do this with IntervalMatch functionality in QlikView.
Check the attched appalication.
Hope this helps you.
-Sridhar
Thanks!
Is it possible to have all on the same table? With this I get an strangew model.
Thanks!