Need to display the order id and quantity based on script logic.

[iahmadmca]

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

[Claudiu_Anghelescu]

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) );

[iahmadmca]

Thank for the reply.

Could you please provide any other alternate solution for this.

[iahmadmca]

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.