Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have one requirement which i need to get the result based on script level. Provided the below requirement details.
I am using the below script logic to get it done but it is not coming.
Order:
LOAD [Order id],
Quantity,
Order_Date
FROM
[C:\Users\Irshad .Ansari\Desktop\Daily work activity.xlsx]
(ooxml, embedded labels, table is Sheet2)
where [Order id]<>1 or Order_Date<>null() and Order_Date<> Previous(Order_Date);
Note: one order_id should be one quantity and quantity Order date should be first inter value it should not be change.
sample data.
Order id | Quantity | Order_Date |
1 | 2 | ------ |
1 | 3 | ------ |
1 | 4 | 1-jun-2019 |
1 | 6 | 1-Jun-2019 |
2 | 7 | 1-Aug-2019 |
3 | 9 | ------ |
Based on the sample data the result should be like this:
Order id | Quantity | Order_Date |
1 | 4 | 1-jun-2019 |
4 | 7 | 1-Aug-2019 |
3 | 9 | -------- |
I would like to request you to please provide the solution.
Thanks in advanced.
Regards,
Irshad Ahmad
where ( [Order id]<>1 or Order_Date<>null() ) and Order_Date<> Previous(Order_Date);
or
where [Order id]<>1 or ( Order_Date<>null() and Order_Date<> Previous(Order_Date) );
Thank for the reply.
Could you please provide any other alternate solution for this.
Hi
This logic is working fine, but when I am changing the quantity for existing Id its getting reflect on that. The quantity should not be changed. It should be first entered in quantity.