Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a table like this:
Name Manager Change Date
Julien Robert 01/02/17
Julien Mikael 01/07/17
Marc Paul 01/03/17
I'd like a table like this:
Name Manager Date
Julien Robert 01/02/17
Julien Robert 02/02/17
...
Julien Robert 30/06/17
Julien Mikael 01/07/17
...
Julien Mikael 25/10/17
Marc Paul 01/03/17
Marc Paul 02/03/17
...
Any idea?
Thanks!
Im not sure what the difference is could you upload your app or a screen shot of data etc...
Hey Julien,
Put an order by in your script.
Load
*
from
blablabla.qvd
order by
Name,Manager,Date Desc;
in the first table: one entry per each manager change, with the corresponding date
in the second table: one entry per day, with the corresponding manager
It is not the subject
the current table: one entry per each manager change, with the corresponding change date
the table I would like to create: one entry per day, with the corresponding manager
ahhh...
Well, maybe this:
Your_Table:
Manager,
Date
from yourqvd
Left Join(Your_Table)
Load
Name,
Manager
From yourqvd;
no, thank you