Help

[panipat1990]

Hi Team,

I have an excel With Many Fields....And there is Many Dates in Date Column..But i Want to Maxium Date From Date Column..How is it possible..Please Help me...  So For clearing i am attaching excel ....

[sunny_talwar]

Max Date for the overall date set? or max per customer? Can you elaborate on the expected output?

[panipat1990]

IN Date Column i want to show only maximum date Just only one date(maximum date).

[panipat1990]

Yes Max Date for the overall date set...

[sunny_talwar · Accepted solution]

May be try this:

Table:

LOAD CustomerID,

    EmployeeID,

    Freight,

    OrderDate,

    OrderID,

    ShipperID

FROM

excel_Testing.xls

(biff, embedded labels, table is Sheet1$);

Right Join (Table)

LOAD Max(OrderDate) as OrderDate

Resident Table;