Hello! Has anyone tried adding an Output item that includes something like "Segment Number?"
Our direct mail lists have multiple segments, and then often I complete some manual manipulation & deletion after extracting. But it would be helpful to know who is in a "high priority" segment and should not be cut from the list. I do not want to handle this through sources; I want just one source for the mailing piece.
I can't figure out an easy way to do this, so I'm wondering if anyone else has found a trick. Thank you!
This gives you Segment number and you could put it into a view
select a.ka_no as extraction_id, a.description as extraction, b.keycode as segment_no, b.description as segment, c.customer_no, suppression_flag from BIExtract.T_KA_HEADER a Join BIExtract.T_KEYCODE b on a.ka_no = b.ka_no join BIExtract.T_CUST_KEYCODE c on b.keycode = c.keycode and a.ka_no = c.ka_no where suppression_flag = 'N' -- and a.ka_no = 1144 Order by a.ka_no, b.keycode, c.customer_no