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. IDsTitleDescriptionPoint1Point212345Indirect/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 preparationReported Area: XYZ : GLA LE (ID:N123)Process Area : ABC : BP VC (ID:1245)89456Indirect/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 system2Reported Area: XYZ : GLA LE (ID:N123)Process Area : ABC : BP VC (ID:1245) Require Format : ID : * Point1 * Point2 Email should be one below the other. Attaching sample format. Capture.JPG

Consolidate Multiple Columns and Draft Email

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>

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

Reporting

@GayatriPanigrahi
please find attached
this will solve the issue

please mark as done if this is resolved

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

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

@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 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
please find attached
this will solve the issue

please mark as done if this is resolved