Putting condition while loading from an excel file

[bimala0507]

Hi:

I am trying to load an excel file into qlikview. While loading, I have some condition to satisfied e.g. pick up the recod with Maximum PO_date.

E.g

If I have records like as given below

BATT_SPC1520	E0001AU	4500020067	1/9/2014	10	2.76
BATT_SPC1520	E0038US	4500020067	1/8/2014	10	2.76
BATT_SPC1520	E0039US	4500020067	1/7/2014	10	2.76

I would like to load only the record maximum po_date i.e. here the first row.

I think I should go for precendent load option, but not sure how to go about it.

Any quick help would be higly appreciated.

Rgds,

Bimala

[bimala0507]

Hi:

This is  really good way of handling this scenario. Thanks a lot.

Thanks & Regards,

Bimala

[arsal_90]

Ok Bimla So can u refer this post as answer for other people reference

Thanks & regards

MUHAMMAD