the field contains 2 emails

CiaoPaola

Hi, 

the legacy table contains a single Email column that may contain 2 emails separated with a whitespace. 

The target table contains two Email fields : Email1 and Email2. 

I need to put the second email into the Email2 field. 

I cannot figure out how to do that. Can you help me? 

thank you

Paola

AkimasaKajitani

Hi @CiaoPaola 

I added the your sample and then I change the workflow.

If the 2 emails row contain miss type, the workflow will not work well.

But it is work well at your sample.

Workflow

I split the contain 2 email or not and then I replace space on the data stream that not contain 2 email.

After that, I union 2 data stream and split the space.

Input

Result

SplitEmail_AK.yxmd