If Transaction date is the most recent

[#1]

Hi Experts

I hope you can help,

I currently load numerous Excel files into my dashboard.

Once of the fields is a Date and Time field. I am looking to identify the rows of data where the date is the highest. So in example below where date is the 7 / Jan

App             Type          Stamp                            High   

1               Food          01/01/2014  15:15:00          No

1               Food          01/01/2014  18:15:00          No

1               Food          07/01/2014  15:15:00          Yes

1               Food          02/01/2014  15:15:00          No

1               Food          07/01/2014  18:15:00          Yes

1               Food          06/01/2014  15:15:00          No

I think it should be something like this but cant quite tweak it - any help really appreciated

if (max(date(date(Stamp))),"Yes","No") as High

Thanks

A

[sunilkumarqv]

See attached Please

i did what you want

[sunilkumarqv]

try this

Ta:

LOAD   * Inline

[

App,Type,Stamp,High  

1,Food,01/01/2014  15:15:00,No

1,Food,01/01/2014  18:15:00,No

1,Food,07/01/2014  15:15:00,Yes

1,Food,02/01/2014  15:15:00,No

1,Food,07/01/2014  18:15:00,Yes

1,Food,06/01/2014  15:15:00,No

];

NoConcatenate

ta1:

LOAD SubField(Stamp,' ',1) as Date

Resident Ta;

Join

LOAD App,Type, max(Date) as Stamp ,'Yes' as High

Resident ta1;