Load Field with MAX date

[#1]

Hi need help,

Example;

TableA:

Field Header:         Order     |         Date     |         Customer       |    

Field Content:          A                12/11/2014               John                                    

                                A                12/10/2014                John                                    

                                B                12/07/2014                Paul                                   

                                B                12/05/2014                Paul                                     

What I need is a load statement which would give me as an output the Order with the latest Date.

Expected results:

Order           Date

A               12/11/2014

B               12/07/2014

[#2]

I understand but my source isn't so clever unfortunately

[Anonymous · Accepted solution]

In that case you may start encouraging them to do that

What if they want you to tell them how many customers they have? Count which field?

It's impossible to be sure.

BR

Serhan

[Anonymous]

yes that's right

[its_anandrjs]

Hi,

Data should be consistent in this case they not change otherwise result changes if so then the proper field names is used with Key fields.

Regards
Anand