Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @umerfa, please check if this works for you :
Data:
Load distinct
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User]
From YourSource;
left join
Load
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User],
max(Time) as Time
From YourSource
Group By
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User];
Hi @umerfa, please check if this works for you :
Data:
Load distinct
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User]
From YourSource;
left join
Load
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User],
max(Time) as Time
From YourSource
Group By
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User];
Hi QFabian, this works for me, Thank you so much
thanks you @umerfa