I need some help to duplicate the rows based on the scenario names. scenario names and count will keep changing month-on-month. In the current month, there are three scenario and I need the complete data set to be copied thrice and putting the Scenario name in a existing column. S.No SCENARIO 1 BAC Adverse 2 BAC China Conflict 3 BAC Severely Adverse Data set Name SCENARIO COR_LOB Total BOA BAC Baseline D & SB 15 CITI BAC Baseline CS 18 JP BAC Baseline DFS 22 Required result Name SCENARIO COR_LOB Total BOA BAC Baseline D & SB 15 CITI BAC Baseline CS 18 JP BAC Baseline DFS 22 BOA BAC Adverse D & SB 15 CITI BAC Adverse CS 18 JP BAC Adverse DFS 22 BOA BAC China Conflict D & SB 15 CITI BAC China Conflict CS 18 JP BAC China Conflict DFS 22 BOA BAC Severely Adverse D & SB 15 CITI BAC Severely Adverse CS 18 JP BAC Severely Adverse DFS 22

Wanted to duplicate the rows based on the scenario.

I need some help to duplicate the rows based on the scenario names. scenario names and count will keep changing month-on-month. In the current month, there are three scenario and I need the complete data set to be copied thrice and putting the Scenario name in a existing column.

S.No	SCENARIO
1	BAC Adverse
2	BAC China Conflict
3	BAC Severely Adverse

Data set

Name	SCENARIO	COR_LOB	Total
BOA	BAC Baseline	D & SB	15
CITI	BAC Baseline	CS	18
JP	BAC Baseline	DFS	22

Required result

Name	SCENARIO	COR_LOB	Total
BOA	BAC Baseline	D & SB	15
CITI	BAC Baseline	CS	18
JP	BAC Baseline	DFS	22
BOA	BAC Adverse	D & SB	15
CITI	BAC Adverse	CS	18
JP	BAC Adverse	DFS	22
BOA	BAC China Conflict	D & SB	15
CITI	BAC China Conflict	CS	18
JP	BAC China Conflict	DFS	22
BOA	BAC Severely Adverse	D & SB	15
CITI	BAC Severely Adverse	CS	18
JP	BAC Severely Adverse	DFS	22

Dynamic Processing

Accepted answers

ShankerV

Hi @akumar2609

Dataset 1:

Dataset 2:

Append fields tool:

Union tool:

Expected Result:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

All comments

ShankerV

Hi @akumar2609

This can be easily achieved with the help of append fields tool.

Many thanks

Shanker V

ShankerV

Hi @akumar2609

Please find the expected output below.

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

Felipe_Ribeir0

Hi @akumar2609

One way of doing this

append.yxmd

ShankerV

Hi @akumar2609

Dataset 1:

Dataset 2:

Append fields tool:

Union tool:

Expected Result:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703