Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Consolidate Multiple Columns and Draft Email

GayatriPanigrahi
8 - Asteroid

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.

IDsTitleDescriptionPoint1Point2
12345Indirect/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)
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 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.

 

 

 

5 REPLIES 5
Rhys_Cooper
9 - Comet

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

Raj
16 - Nebula

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

GayatriPanigrahi
8 - Asteroid

@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
8 - Asteroid

@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
16 - Nebula

@GayatriPanigrahi 
please find attached 
this will solve the issue 

please mark as done if this is resolved

Labels
Top Solution Authors