Repeating Values of one Field into the next

gitguto — Fri, 19 Nov 2021 05:08:16 GMT

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

Re: Repeating Values of one Field into the next

AshutoshBhumkar — Fri, 19 Nov 2021 06:27:20 GMT

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

topic Repeating Values of one Field into the next in App Development

Repeating Values of one Field into the next

Re: Repeating Values of one Field into the next