topic Modify a table with start and end date into a new one with rows for each date in QlikView

Modify a table with start and end date into a new one with rows for each date

Sun, 23 Jan 2011 14:24:07 GMT

Hello!

I'm new with Qlikview and would appreciate any advise on how to transform my original table into below described table.

Original table:

Name	Start date	End date
A	20100101	20100103
B	20100102	20100103
A	20100107	20100107

New target table

Name	Date
A	20100101
A	20100102
A	20100103
A	20100107
B	20100102
B	20100103

I guess this could be done easily with some kind of loop?

Thanks in advance!

Markus

AW:Modify a table with start and end date into a new one with rows for each date

Sun, 23 Jan 2011 15:11:55 GMT

Hi Markus,

I am searching in vain for the transform rules. How is your translating algorithmn working? e.g. how did you get record "A 2010102" ? Into what did you transform your third source-record?

Regards, Roland

AW:Modify a table with start and end date into a new one with rows for each date

Sun, 23 Jan 2011 15:23:44 GMT

Hello Roland!

I think I made a mistake, the table was just created as a quick example..

I found what I was looking for here.

http://community.qlik.com/forums/p/25369/96833.aspx#96833

Thanks for your concern!

Markus