I am trying to make our email list include multiple control grouped emails on a single constituent (Orgs with multiple emails, individuals with a work/personal email) and followed this recipe to create the output set: https://www.tessituranetwork.com/Help_System/Tessitura.htm#Recipe%20Books/Output%20Sets/Emails.htm
According to WordFly documentation (https://support.wordfly.com/hc/en-us/articles/204768454-Set-up-an-output-set#h_85f7f797-7cf1-4c20-86e4-85030f170047) you can't use lists that have output set elements with multiple rows:
Is anybody doing this without manually exporting a list to .csv and manually uploading it into Wordfly? Very frustrating.
It is possible to engineer an output set with multiple email addresses per constituent. As long as you have one row per unique email address, WordFly is fine with this. You will likely need to create your own custom output set elements to accomplish this, however. I believe I needed to "lie" to WordFly by defining an element that did return multiple rows, but was configured as "single row" in system tables, which is what WordFly checks for when validating output sets. The other caveat is that your unsubscribe/preference updating may not expect this kind of behavior, so make sure you understand how those updates are populated back to your database and make any adjustments as necessary.
ha, so that Single Row check in tr_query_element is basically a warning light for the user side? it doesn't actually prevent more than one row if your output set element is getting more than one row? I checked it and the indicator on my output set is gone, and I can upload into WF with no problem. sigh.. Thanks Nick!