Combine bar charts with custom text from separate column

Question

Hi! Looking for some help with this please.... I have 2 bar charts that are outputs from 2 interactive charts and I want to combine a custom text from another column that is held on select tool. What's unique to all 3 outputs is the "Traveler Name" field. Where we want to get is to be able to send a customizable email to each individual and in that email, have the barcharts and custom text for each staff member

Workflow.png

DanielRod · Answer

Hi! I tried the Report Text tool, but it doesn't create 2 separate columns, one for the individual names and one for the custom text, it just merges the 2 columns into one. I assume I need to keep the names on a separate column as that is what will identify the charts and custom text for which individual, right? Thank you!

SGolnik · Answer

For the custom text, you can use the report text tool, but you will need to set this up as a batch macro if the text is custom to each person.

Check out this similar community post for the customizable email: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Creating-a-Batch-Macro-to-email-multiple-users-different-results/td-p/501699