Data Preparation

[Ragini1]

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 1	Level 2	Assignment
10000	100001	3100004
10000	100001	3100005
10000	100001	3100006
10000	100001	3100007
10000	100002	3100008
10000	100002	3100009
10000	100002	3100010
10000	100002	3100011
20000	200001	3100012
20000	200001	3100013
20000	200001	3100014

Output->

High Level Group	Low Level Group	Profit Center
	10000
10000	100001
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

[ggruccio · Accepted solution]

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.

[pedrodrfaria]

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:

Pedro.