Adding New Columns with Company Name

[Divyajyothi7]

Hi

• I have two datasets: co1 and co2.
• In co1, there is a hierarchical relationship between parent and child records.
• I have last child record in co1.
• Once you have identified the last child record, you want to continue the data from co2 and create a new column called "co".
• Sample data for co1 and co2 has been added with workflow.

Input :

od t_mi

od t_si

od t_qa

t_si

t_qa

t_si2

t_qa2

t_si3

t_qa3

t_si4

t_qa4

t_si5

t_qa5

t_si6

t_qa6

t_si7

t_qa7

t_si8

t_qa8

t_si9

t_qa9

SD001

SD022

1

SD122

0.23

SD099

0.33

SD400

0.66

SD123

0.11

SD124

0.22

SD125

0.44

SD211

0.55

SD077

SD088

0.33

SD233

0.55

SD199

0.55

SD433

0.77

SD544

0.88

SD234

0.56

SD235

0.34

SD236

0.55

SD237

0.56

SD238

2

SD077

SD188

0.23

SD444

0.55

SD199

0.22

SD544

0.88

SD911

0.1

SD111

1

SD102

1

Expected Output:

od t_mi	co	od t_si	co	od t_qa	t_si	co	t_qa	t_si2	co	t_qa2	t_si3	co	t_qa3	t_si4	co	t_qa4	t_si5	co	t_qa5	t_si6	co	t_qa6	t_si7	co	t_qa7	t_si8	co	t_qa8	t_si9	co	t_qa9
SD001	111	SD022	111	1	SD122	111	0.23	SD099	111	0.33	SD400	111	0.66				SD123	1133	0.11	SD124	1133	0.22	SD125	1133	0.44	SD211	1133	0.55
SD077	111	SD088	111	0.33	SD233	111	0.55	SD199	111	0.55	SD433	111	0.77	SD544	111	0.88	SD234	1133	0.56	SD235	1133	0.34	SD236	1133	0.55	SD237	1133	0.56	SD238	1133	2
SD077	111	SD188	111	0.23	SD444	111	0.55	SD199	111	0.22	SD544	111	0.88				SD911	1133	0.1	SD111	1133	1	SD102	1133	1

[geraldo · Accepted solution]

@Divyajyothi7 

An example workflow follows.

As Alteryx cannot have columns with the same name, the Co column was unique. If the example works, make the necessary adjustments

[binuacs · Accepted solution]

@Divyajyothi7 Another approach, 

[flying008 · Accepted solution]

Hi, @Divyajyothi7 

Another way by MM-Formula only for reference, but not recommend.