topic Re: Date in App Development

Date

jleberre — Wed, 25 Oct 2017 13:06:29 GMT

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!

Re: Date

Anonymous — Wed, 25 Oct 2017 13:21:09 GMT

Im not sure what the difference is could you upload your app or a screen shot of data etc...

Re: Date

eduardo_dimperio — Wed, 25 Oct 2017 13:46:00 GMT

Hey Julien,

Put an order by in your script.

Load

from

blablabla.qvd

order by

Name,Manager,Date Desc;

Re: Date

jleberre — Wed, 25 Oct 2017 16:06:28 GMT

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

Re: Date

jleberre — Wed, 25 Oct 2017 16:08:47 GMT

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

Re: Date

eduardo_dimperio — Wed, 25 Oct 2017 16:25:02 GMT

ahhh...

Well, maybe this:

Your_Table:

Manager,

Date

from yourqvd

Left Join(Your_Table)

Load

Name,

Manager

From yourqvd;

Re: Date

jleberre — Thu, 26 Oct 2017 06:32:04 GMT

no, thank you