Generate Rows and edit column

[maxiemens]

Hi Alteryx Users,

I have the following example for my problem: 

This ist my Input:

I want to generate 6 new rows for PCS like this: 

And now I want to rename 5 of the 6  'PCS' like this: 

Does anybody know how I can do this?

Thanks in Advance.

[BenMoss · Accepted solution]

Personally, I would approach the task in a way that makes it easy to update should you wish to add 'new names' into your source. 

To do that, I recommend storing those different names in a input file of sorts, in this example, I've used a text input.

You can then append these records against your PCS value to create all of your new rows, before unioning them both together. 

Attached is an example.

Ben