Adding a row with Static values

[Kuldeepmathur]

Hi,

Thanks in advance.

I would like your help as whenever my Id is changing I need to add a row with having a value of the previous row **just in the access column I need Name Value.

I/p

Name	Id	Access
Franklyn	1850	Nel
Franklyn	1850	Stul
Grey	3434	Hik
Grey	3434	Phill
Maj	1063	Kroll
Maj	1063	Otaki

Expected O/p

Name	Id	Access
Franklyn	1850	Nel
Franklyn	1850	Stul
Franklyn	1850	Franklyn
Grey	3434	Hik
Grey	3434	Hof
Grey	3434	Grey
Maj	1063	Kroll
Maj	1063	Otaki
Maj	1063	Maj

Thanks 🙂

[Christina_H]

Here you go.

[Luke_C · Accepted solution]

Hi @Kuldeepmathur 

Here's one approach:

1. Sample one record from each ID. 
2. Update the 'Access' field of that record to be equal to the 'Name'
3. Union those records back and sort

[HomesickSurfer]

Hi @Kuldeepmathur 

EDIT:  Not as clean as solutions provided by others... 🙂

Here's one way to accomplish the task:

Workflow attached.