topic Flag first occurrence during load in QlikView

Flag first occurrence during load

Wed, 08 Jul 2015 13:15:33 GMT

Hi,

I have a dataset with difference numbers of multiple instances eg :

ID	user	Date
1522448	MJP	01/05/2014
1522448	MJP	12/08/2014
1522448	MJP	03/01/2015

There can be anything from 1 instance upto 10 or 12. In the above example, I need to Flag the record with the Date of 01/05/2014 as being the First record using the ID and User as being the same.

Any help appreciated.

Tom

Re: Flag first occurrence during load

alexandros17 — Wed, 08 Jul 2015 13:21:47 GMT

In the script;

Tab:
LOAD * Inline [
ID, user, Date
1522448, MJP, 01/05/2014
1522448, MJP, 12/08/2014
1522448, MJP, 03/01/2015
];

Left Join
LOAD ID, user, Min(Date) as Date, 1 as myFlag Resident Tab Group By ID, user;
Resident Tab Group By Customer;

Re: Flag first occurrence during load

Wed, 08 Jul 2015 13:25:01 GMT

perfect thanks!

Re: Flag first occurrence during load

Anonymous — Wed, 08 Jul 2015 13:25:21 GMT

PFA