I am trying to add a personalization block for a first name field that is not directly in the recipient schema.
The one pecular thing I am noticing is that the '_1toM' gets added when trying to include this variable from the email template. Is it possible to grab a value from a one to many table?
I believe that you can set audience level in the first query activity node to Event Registration table and pass the first/last names. Later in the workflow, you can change the audience level to recipient table and that will keep the first/last names columns and make them available to the delivery. Limiting the query to new registration events (assuming this is a recurring campaign) and using the dedup activity node (if needed) can help you ensuring a person gets one communication if he/she registered multiple times in a given period.