Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ....
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;
Max Date for the overall date set? or max per customer? Can you elaborate on the expected output?
IN Date Column i want to show only maximum date Just only one date(maximum date).
Yes Max Date for the overall date set...
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;