Creating new rows & splitting up text strings

[Anonymous]

    Hello Experts!

Here is how my marketing campaign table looks like now. I am simplifying for the sake of discussion. Each unique email that is used by marketing campaigns is listed once and the campaigns utilizing that email are listed in one cell separated by a semi-colon (see below).

Campaign name	lead Email
Campaign A; Campaign B; Campaign C	aaffqa#@gmail.com

Here is how I want this to look so I can more easily manipulate the data in the future:

Campaign name	Email
Campaign A	aaffqa#@gmail.com
Campaign B	aaffqa#@gmail.com
Campaign C	aaffqa#@gmail.com

How do I do this? I have no idea.

[sunny_talwar]

Try this:

LOAD SubField([Campaign name], '; ') as [Campaign name],

           [lead Email] as Email

FROM ....

[maxgro]

with subfield (replace with your field names)

load SubField(f1, ';') as f11, f2 Inline [

f1, f2

Campaign A; Campaign B; Campaign C , aaffqa#@gmail.com

];

[sunny_talwar]

Sample script:

Table:

LOAD SubField([Campaign name], '; ') as [Campaign name],

          [lead Email] as Email;

LOAD * INLINE [

    Campaign name, lead Email

    Campaign A; Campaign B; Campaign C, aaffqa#@gmail.com

];