Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey evrybody, I have a 'small' problem, so I have the follow script
Sales:
LOAD * INLINE [
code, OrderDate,total
1, 16.07.2014,10
2, 16.07.2014,52
3, 16.07.2014,588
1, 17.07.2014,855
3, 17.07.2014,452
4, 17.07.2014,542
];
code:
NoConcatenate LOAD
Distinct
code
Resident Sales;
Left Join(code)
LOAD
code,
OrderDate,
total
Resident Sales;
DROP Table Sales;
EXIT Script;
I would like to get 2 lists:
list of items that were sold the 16.07.2014 and were not sold the 17.07.2014 |
---|
code |
2 |
list of items that were sold the 17.07.2014 and were not sold the 16.07.2014 |
---|
Code |
4 |
Please could sombody helps me ? 😞
thanks
Best
Army
Hi,
Try like this
For List 1:
Dimension: code
Expression: =Only({<OrderDate={'16.07.2014'}, code = E({1<OrderDate={'17.07.2014'}>})>} code)
For List 2:
Dimension: code
Expression: =Only({<OrderDate={'17.07.2014'}, code = E({1<OrderDate={'16.07.2014'}>})>} code)
Hope this helps you.
Regards,
jagan.
Hello,
I let this solution, I hope you serve
Hi,
Try like this
For List 1:
Dimension: code
Expression: =Only({<OrderDate={'16.07.2014'}, code = E({1<OrderDate={'17.07.2014'}>})>} code)
For List 2:
Dimension: code
Expression: =Only({<OrderDate={'17.07.2014'}, code = E({1<OrderDate={'16.07.2014'}>})>} code)
Hope this helps you.
Regards,
jagan.
Hey Jagan
just wan to say Thanks
Best
Armand