Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to add multiple text templates in Report text Dynamically

Saravanan13
8 - Asteroid

Hello All,

 

I am looking to create a template using report text tool and later need to send email. Template should be created based on the account type dynamically.

Whenever there are multiple account types for a single ID then the legal docs needs to be combined and added to the template in the below format.

 

Template data-

 

Account TypeLegal Docs
Entity1. Entity documents
2.Entity documents
3.Entity documents
4.Entity documents
Trust 1.Trust document
2.Trust document
3.Trust document
Estate1.Estate document
2.Estate document
Individual1. Individual document

 

 

Report text output format-

 

IDAccount TypeLegal Docs
12456Entity,Trust1. Entity documents
2.Entity documents
3.Entity documents
4.Entity documents
1.Trust document
2.Trust document
3.Trust document
5555Entity,Trust,Estate1. Entity documents
2.Entity documents
3.Entity documents
4.Entity documents
1.Trust document
2.Trust document
3.Trust document
1.Estate document
2.Estate document
666666Entity1. Entity documents
2.Entity documents
3.Entity documents
4.Entity documents
4444444Individual1.Indvidual document
222222Individual,Trust1. Individual document
1.Estate document
2.Estate document
7777777Indvidual,Entity1. Indviidual document
1. Entity documents
2.Entity documents
3.Entity documents
4.Entity documents

 

2 REPLIES 2
stataltgee
8 - Asteroid

@Saravanan13 shouldn't this be "trust document" in below cell? Also you haven't added the ID for 'trust' account type. Is it not there in the output? 

222222Individual,Trust1. Individual document
1.Estate document
2.Estate document
Saravanan13
8 - Asteroid

yeah you are correct, Its a copy paste error. can you assist on this please

Labels
Top Solution Authors