How do I return the given latest in a line?

[#1]

    Good afternoon,

    I'm trying to filter the last order status customers. Except that nothing in the manual about the last date to be selected, only loading.

Below is an example of what I need.

Sample database:

NAME	IDENTIFICATION NUMBER	PRODUCT	DATE	STATUS
JOSE	5424658	SHIRT	02/04/2015	DELIVERED REQUEST
MARIA JOSE	5169469	TENNIS	20/03/2015	AWAITING DELIVERY
MARIA JOSE	5169469	TENNIS	24/04/2015	DELIVERED REQUEST
JOAQUIM	498562	TENNIS	17/04/2015	DELIVERED REQUEST
Anastacia	892323	BLOUSE	04/05/2015	AWAITING DELIVERY
JURESMAR	985620	SHIRT	20/03/2015	AWAITING DELIVERY
MARIANA	5156623	SHIRT	11/05/2015	DELIVERED REQUEST
JOHN	5159396	SHOE	22/05/2015	AWAITING DELIVERY

When filter by status:

NAME	IDENTIFICATION NUMBER	PRODUCT	DATE	STATUS
JURESMAR	985620	SHIRT	20/03/2015	AWAITING DELIVERY
JOHN	5159396	SHOE	22/05/2015	AWAITING DELIVERY
Anastacia	892323	BLOUSE	04/05/2015	AWAITING DELIVERY
MARIA JOSE	5169469	TENNIS	20/03/2015	AWAITING DELIVERY

Real status:

NAME	IDENTIFICATION NUMBER	PRODUCT	DATE	STATUS
JURESMAR	985620	SHIRT	20/03/2015	AWAITING DELIVERY
JOHN	5159396	SHOE	22/05/2015	AWAITING DELIVERY
Anastacia	892323	BLOUSE	04/05/2015	AWAITING DELIVERY

[sebastiandperei]

You need this in an object or in script?

Could you please send a reduced qvw copy?

[Anonymous]

I assume that 'MARIA JOSE' should be excluded because the 'AWAITED DELIVERY' is not the latest status.

If this is correct, you maybe want to create a "Latest Status" flag in the script, and on the front-end objects use this flag as a condition (set analysis) to show the records where this flag is true.

Or maybe you want to load only the records with the current status?  I can't guess the exact requirements...

[petter · Accepted solution]

This might be what you are looking for?

Expressions:

Latest Update:    Max( DATE )

Status:               Max( Status )

Process:             Concat( Date( DATE , 'YY-MM-DD' ) & ' :  ' & STATUS , ' /  ', DATE )

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco

[sinanozdemir]

Another approach that is similar to Marco's solution:

get the maximum of dates and group by names then left join.

And in the expression, just use if max date is equal to date to pull the most update status.

Just another approach.

[#7]

it would be better on an object , I could accomplish in Excel using dynamic table , sorting by date, and deleting duplicates .

[#8]

Thanks! I managed to make the filter, follow the steps that you put in qvw.