Repeating Values of one Field into the next

[gitguto]

Hello folks, 

Let's get right into it,

Example, this is what I have:

Table1:

Name	Last Name
Bob	Marley
Bob	Nelson
Peter	Tosh
Kate	Kate
Kate	Winslet
Kate	Perry

This is what I need:

Table2:

Name	Last Name
Bob	Bob
Bob	Marley
Bob	Nelson
Peter	Peter
Peter	Tosh
Kate	Kate
Kate	Winslet
Kate	Perry

Notice that I wont add an extra "Kate" in Table 2 because I already have the combination Kate - Kate in Table 1.

I appreciate any help, any workaround in set analysis or script will do. thank you

[AshutoshBhumkar]

Hello,

Try below script.

Table:
Load Name&'-'&"Last Name" as Key, Name, "Last Name" Inline [
Name,Last Name
Bob,Marley
Bob,Nelson
Peter,Tosh
Kate,Kate
Kate,Winslet
Kate,Perry
];

Concatenate

Table1:
Load Name as Name,Name as "Last Name" Resident Table where not Exists(Key, Name&'-'&Name);

Exit Script;

Thanks,
Ashutosh