Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convertin DateFrom - DateTo registers to one register per day.

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!!

1 Solution

Accepted Solutions
sridhar240784
Creator III
Creator III

Hi,

You can do this with IntervalMatch functionality in QlikView.

Check the attched appalication.

Hope this helps you.

-Sridhar

View solution in original post

5 Replies
sridhar240784
Creator III
Creator III

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

Not applicable
Author

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

sridhar240784
Creator III
Creator III

Hi,

You can do this with IntervalMatch functionality in QlikView.

Check the attched appalication.

Hope this helps you.

-Sridhar

Not applicable
Author

Thanks!

Not applicable
Author

Is it possible to have all on the same table? With this I get an strangew model.

Thanks!