Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Contributor III

Re: Convertin DateFrom - DateTo registers to one register per day.

Hi,

You can do this with IntervalMatch functionality in QlikView.

Check the attched appalication.

Hope this helps you.

-Sridhar

5 Replies
sridhar240784
Contributor III

Convertin DateFrom - DateTo registers to one register per day.

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

Convertin DateFrom - DateTo registers to one register per day.

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
Contributor III

Re: Convertin DateFrom - DateTo registers to one register per day.

Hi,

You can do this with IntervalMatch functionality in QlikView.

Check the attched appalication.

Hope this helps you.

-Sridhar

Not applicable

Re: Convertin DateFrom - DateTo registers to one register per day.

Thanks!

Not applicable

Re: Convertin DateFrom - DateTo registers to one register per day.

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

Thanks!

Community Browser