Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
how do I create an key for the orders that contains a line that ends with 300.
I would like to be able to show all order lines from the order number that
contains 300, see order file below.
Håkan
0364227481000100
0364227481000105
0364227481000110
0364227481000200
0364227481000205
0364227481000210
0364227481000300
0364655361000100
0364655361000105
0364655361000200
0364655361000205
0364655421000100
0364655421000105
0364655421000200
0364655421000205
Hi,
Load * from Table where field='*300';
Regards,
Joshmi
You can Use like below in the script:
if(WildMatch(Order,'*300'),Order) as Order300
P.S:
LOAD Order,if(WildMatch(Order,'*300'),Order) as Order300 INLINE [
Order
0364227481000100
0364227481000105
0364227481000110
0364227481000200
0364227481000205
0364227481000210
0364227481000300
0364655361000100
0364655361000105
0364655361000200
0364655361000205
0364655421000100
0364655421000105
0364655421000200
0364655421000205];
Thanks,
Singh
Hi Hakan,
try something like this:
if(Right(OrderNo,3)='300',1,0) AS Order_Flag
Andy