There are a few good posts on the topic. Remember that your REDUCTION field values must always be caps, using an upper(VALUE) as REDUCTION function can help. Should be fairly straightforward to figure out from the link below. If you're using multiple tables make sure REDUCTION value is generated on each table or the data won't load.