Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | ||||||||||||||||
|
I guess this could be done easily with some kind of loop?
Thanks in advance!
Markus
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
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