Hello all!
I'm wondering if there's a way to pinpoint which segment (inclusion or suppression) a specific individual (or household) is populated into in an extraction?
Thanks!
- Dave Toropov
Annual Fund Coordinator
Chicago Shakespeare Theater
Hi Dave, I'm not sure there's an easy way of doing this from within the application - via SQL it's quite easy,if, of course, you are either a dba or have access to one. What I've done here so that users can do this sort of thing for themselves though, is create a couple of local views (to deal with the fact that the Extraction details exist in a their own, separate database) and then create elements based on the views so that the detail can be used in an Output Set. You'd need your dba/SQL whizz to create the views. If you're interested in getting the finer details and SQL to create the views, drop me a line martin.keen@nida.edu.au. Martin From: Dave Toropov <bounce-davetoropov6494@tessituranetwork.com> Sent: 12/2/2016 5:27:29 PM Hello all! I'm wondering if there's a way to pinpoint which segment (inclusion or suppression) a specific individual (or household) is populated into in an extraction? Thanks! - Dave Toropov Annual Fund Coordinator Chicago Shakespeare Theater This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi Dave,
I'm not sure there's an easy way of doing this from within the application - via SQL it's quite easy,if, of course, you are either a dba or have access to one.
What I've done here so that users can do this sort of thing for themselves though, is create a couple of local views (to deal with the fact that the Extraction details exist in a their own, separate database) and then create elements based on the views so that the detail can be used in an Output Set. You'd need your dba/SQL whizz to create the views.
If you're interested in getting the finer details and SQL to create the views, drop me a line martin.keen@nida.edu.au.
Martin
From: Dave Toropov <bounce-davetoropov6494@tessituranetwork.com> Sent: 12/2/2016 5:27:29 PM
Sadie,
Yours is a MUCH better/easier solution. I really need to wean myself off my love of SQL............
Martin,
There is a place in the eco-system for all the tools. It is great that there can be so many valid approaches.
That is genius, Sadie. As a SQL fan, I echo Martin's sentiments!