Consolidate Multiple Columns and Draft Email

[GayatriPanigrahi]

Hi Team,

Need to generate draft email using below dataset.

I have used Table tool from Reporting category to format the columns, need help to consolidate it.

IDs	Title	Description	Point1	Point2
12345	Indirect/Near Incorrect CO C123.03 03 (Top 20)	Summary:  Columns 0050 and 0060 in the file report CO has been incorrectly represented during the submission blah blah blah. Background: As per the system technical standards, these AVA columns on C32.03 should be presented using pre-diversification levels. Issue:  The impacted columns instead were shown as post-fgshdg (the correct figures should have been twice the numbers reported). Operational error was caused by selecting an incorrect field when translating the data from system1 to system2 Identification: Error was identified during the preparation	Reported Area: XYZ : GLA LE (ID:N123)	Process  Area : ABC : BP VC (ID:1245)
89456	Indirect/Near Incorrect CO C123.03 03 (Top 10)	Summary:  Columns 0050 and 0060 in the file report CO has been incorrectly represented during the submission blah blah blah. Background: As per the system technical standards, these AVA columns on C32.03 should be presented using pre-diversification levels. Issue:  The impacted columns instead were shown as post-fgshdg (the correct figures should have been twice the numbers reported). Operational error was caused by selecting an incorrect field when translating the data from system1 to system2	Reported Area: XYZ : GLA LE (ID:N123)	Process  Area : ABC : BP VC (ID:1245)

Require Format :

ID <IDs>: <Title>

<Description Column - Need to paste as it is>

• Point1
• Point2

Email should be one below the other. Attaching sample format.

[Rhys_Cooper]

May you attach the worklow used to produce this output so far please @GayatriPanigrahi 

[Raj]

@GayatriPanigrahi 
share your sample input file which can be loaded into alteryx.

[GayatriPanigrahi]

@Raj PFA sample file.

@Rhys_Cooper It's a long workflow and multiple input files are used for transformations/calculations to prepare the attached format.  

[GayatriPanigrahi]

@Raj PFA sample file.

@Rhys_Cooper It's a long workflow and multiple input files are used for transformations/calculations to prepare the attached format

[Raj · Accepted solution]

@GayatriPanigrahi 
please find attached 
this will solve the issue 

please mark as done if this is resolved