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

Alteryx Designer Desktop Discussions

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

Data Preparation

Ragini1
8 - Asteroid

 

Hello Everyone,

This is the input and the desired output. Can someone please help me with creating a workflow for this.

 

Regards,

Ragini

Input-->

Level 1Level 2Assignment
10000100001

3100004

10000100001

3100005

100001000013100006
100001000013100007
100001000023100008
100001000023100009
100001000023100010
100001000023100011
20000 2000013100012
200002000013100013
200002000013100014

 

Output->

High Level GroupLow Level GroupProfit Center
 10000 
10000100001 
100001 3100004
100001 3100005
100001 3100006
100001 3100007
10000 100002 
100002 

3100008

100002 3100009
100002 3100010
100002 3100011

 

20000 

20000

200001 

200001

 3100012
200001 3100013
200001 3100014
2 REPLIES 2
ggruccio
ACE Emeritus
ACE Emeritus

Hi @Ragini1,

 

Will this accomplish what you need?  I got there doing various summaries and writing conditional statements in the Formula tool...then just cleaned up the column names at the end.

 

ggruccio_0-1610396251322.png

ggruccio_1-1610396327210.png

 

pedrodrfaria
13 - Pulsar

Hi @Ragini1 

 

I could be getting myself confused, but I thought I had responded to this post, or did you ask the same question twice in a different post? haha. If not someone had the same use case as yours haha.

 

Here is the solution I came up with:

 

pedrodrfaria_1-1610398961040.png

 

Pedro.

 

 

Labels