Wanted to duplicate the rows based on the scenario.

[akumar2609]

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

[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

[ShankerV · Accepted solution]

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