Alteryx Designer Desktop Discussions

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

Data Preparation 2 inputs and output to consolidate Excel in the same worksheet name

sgwong
8 - Asteroid

I would like to seek advice transform 2 different format input source and consolidate output by grouping name/last co & split by sub region.

 

As per attach for 2 inputs and 1 output format to Excel.

4 REPLIES 4
Chaoued
7 - Meteor

the output requirement isn't clear enough but, I'm building a workflow it might help you just adjust it to your need

sgwong
8 - Asteroid

Thank you for your input.

 

I wiuld like my output format table structure as below:

 

Name / Last CO        All Central   Genting Highland     etc.

Name A                   

    Last CO  A1 

    Last CO  A2

 

Name   B                  

    Last CO  B1 

    Last CO  B2

sgwong
8 - Asteroid

How to remove those receord in red in work document for workflow attacged.

 

 

 

sgwong
8 - Asteroid

As per attach for workflow  to get outpur result as expected.

Labels
Top Solution Authors