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>
Email should be one below the other. Attaching sample format.
Solved! Go to Solution.
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
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |