Create a key for certain entries

[#1]

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

[#2 · Accepted solution]

Hi,

Load * from Table where field='*300';

Regards,

Joshmi

[#3]

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

[awhitfield]

Hi Hakan,

try something like this:

if(Right(OrderNo,3)='300',1,0) AS Order_Flag

Andy