Date loading

[Simon_BI]

I need suggestion here.

Below i have six order lines, but i only want to have one order line with the earliest date as the output which means the output should be only one order line with 12/1/2019.

Could someone give a help here? Thanks

30234229, 3420, 12/1/2019, ACN

Order:
LOAD * INLINE [
ITEM, OrderQty, Date, Destination
30234229, 240, 12/31/2019, ACN
30234229, 3270, 12/13/2019, ACN
30234229, 3330, 12/7/2019, ACN
30234229, 3420, 12/1/2019, ACN
30234229, 3450, 12/6/2019, ACN
30234229, 3510, 12/20/2019, ACN
];

[Anil_Babu_Samineni · Accepted solution]

Order:
LOAD ITEM, OrderQty, Date(Date#(Date,'MM/DD/YYYY')) as Date, Destination INLINE [
ITEM, OrderQty, Date, Destination
30234229, 240, 12/31/2019, ACN
30234229, 3270, 12/13/2019, ACN
30234229, 3330, 12/7/2019, ACN
30234229, 3420, 12/1/2019, ACN
30234229, 3450, 12/6/2019, ACN
30234229, 3510, 12/20/2019, ACN
];

Inner Join (Order)
LOAD ITEM, Min(Date) as Date Resident Order Group By ITEM;

[Simon_BI]

That works. Thank you so much Anil.