Hi, this is a simple one...I hope!
We're on V12.5. The Output Element "customer_lname" brings up first AND last names of couples in a household. This is really annoying for us - it means we can't alphabetize lists by last name, which we often need to do if its for an event and tracking RSVPs and reporting on these, as well as for running mailing lists by our CEO...she just wants to check them in alphabetical order!
Is there something wrong with our Output Element...or is there something I'm missing? Or is the Output Element truly this dysfunctional?? Please help :-)
I can't help on the outputs as I'm still a Tess newbie, but I have a great Excel trick you can use in the interim if you are outputting your list to Excel - if you don't know it already. You can use Text to Columns to split the "Mary Smith" column into two, one with just Mary, one with Smith. It goes a bit wonky if you have anyone with three names, but 99% of the time is great. Here is the step by step: support.office.com/.../split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23