Data Preparation-hierarchy

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

pedrodrfaria

HI @Ragini1 

Please see below for the solution you are looking for:

I separated the the workflow into different summarizes doing each part of the table you are trying to get together and then sorting it all by the original order to get it in the correct order and format.

Please assign the solution if your questions have been answered.

Pedro.

Data Preparation-hierarchy.yxmd