We are at the end of our fiscal year and have started an data mining project for grants and foundations. Right now I am working through a 27k excel sheet. Through clever data sorting and conditional formatting I have gotten that number down to 17k. We are trying to squeeze out our unique attendance from this list. The bulk of the work is combining multiple line items into one. For example, we have a patron who has purchased 4 tickets to Westside Story. One of the party is a youth, one is a Young professional, and the rest are adults. When I out put the data through execute and output set, I end up with three rows of data that I have to combine manually.
Is it possible to build a query element that combines all these rows into one? Has anyone had any success building one? Am I using the right tool for this kind of analysis? I have some experience with building query elements with mixed success. I also have some basic SQL skills.
Any help would be appreciated.
Thank you,
Jason Buehrer
Hi Jason, There is a quick little macro in Excel that I found that combines multiple rows into one, based on a unique id (customer id when dealing with tess data, obviously). If you want me to send it to you, you can email me at jkeener@motopera.org From: Jason Buehrer <bounce-jasonbuehrer3484@tessituranetwork.com> Sent: 12/27/2016 2:34:09 PM We are at the end of our fiscal year and have started an data mining project for grants and foundations. Right now I am working through a 27k excel sheet. Through clever data sorting and conditional formatting I have gotten that number down to 17k. We are trying to squeeze out our unique attendance from this list. The bulk of the work is combining multiple line items into one. For example, we have a patron who has purchased 4 tickets to Westside Story. One of the party is a youth, one is a Young professional, and the rest are adults. When I out put the data through execute and output set, I end up with three rows of data that I have to combine manually. Is it possible to build a query element that combines all these rows into one? Has anyone had any success building one? Am I using the right tool for this kind of analysis? I have some experience with building query elements with mixed success. I also have some basic SQL skills. Any help would be appreciated. Thank you, Jason Buehrer This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 Jason,
There is a quick little macro in Excel that I found that combines multiple rows into one, based on a unique id (customer id when dealing with tess data, obviously). If you want me to send it to you, you can email me at jkeener@motopera.org
From: Jason Buehrer <bounce-jasonbuehrer3484@tessituranetwork.com> Sent: 12/27/2016 2:34:09 PM