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