In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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