The input table, antiselect_input, is a sample set of sales data containing 13 columns.
Antiselect Example Input Table antiselect_input (Columns 1-8)
rowid |
orderid |
orderdate |
priority |
quantity |
sales |
discount |
shipmode |
1 |
3 |
2010-10-13 00:00:00 |
Low |
6 |
261.54 |
0.04 |
Regular Air |
49 |
293 |
2012-10-01 00:00:00 |
High |
49 |
10123 |
0.07 |
Delivery Truck |
50 |
293 |
2012-10-01 00:00:00 |
High |
27 |
244.57 |
0.01 |
Regular Air |
80 |
483 |
2011-07-10 00:00:00 |
High |
30 |
4965.76 |
0.08 |
Regular Air |
85 |
515 |
2010-08-28 00:00:00 |
Not Specified |
19 |
394.27 |
0.08 |
Regular Air |
86 |
515 |
2010-08-28 00:00:00 |
Not Specified |
21 |
146.69 |
0.05 |
Regular Air |
97 |
613 |
2011-06-17 00:00:00 |
High |
12 |
93.54 |
0.03 |
Regular Air |
Antiselect Example Input Table antiselect_input (Columns 9-13)
custname |
province |
region |
custsegment |
prodcat |
Muhammed MacIntyre |
Nunavut |
Nunavut |
Small Business |
Office Supplies |
Barry French |
Nunavut |
Nunavut |
Consumer |
Office Supplies |
Barry French |
Nunavut |
Nunavut |
Consumer |
Office Supplies |
Clay Rozendal |
Nunavut |
Nunavut |
Corporate |
Technology |
Carlos Soltero |
Nunavut |
Nunavut |
Consumer |
Office Supplies |
Carlos Soltero |
Nunavut |
Nunavut |
Consumer |
Furniture |
Carl Jackson |
Nunavut |
Nunavut |
Corporate |
Office Supplies |