Wildmatch, wildcard, load statements

[#1]

Hi,

I am trying to create a table which shows regular orders and back orders.

The distinction in my data is the last digit of the order reference.

For example all orders ending in .0 (242.0, 323.0) are the originals, and any orders that end in a digit >0 are the back orders (242.1, 323.6)

How do you suggest i go about splitting the two type of orders? For this example, say i want to sum sales of regular orders and compare it to back orders

I thought of using the wildmatch function or making the distinction in the load but i can't figure out a way to make it work.

Any suggestions please

[swuehl]

I would also add a flag to the table in the load script, maybe:

if(num(right(text(OrderRef),1))>0,'backorder','original') as OrderType,