separation and combination of fields

[Himal]

Hi all,

I want to separate.  username and domain name from an email id and combine address and pin in one column. Can anyone help me in this?

I am attaching the dummy data.

Thanks.

Himal.

[bharti_dalal · Accepted solution]

Hi @Himal,

I am attaching the solve workflow. Hope it helps.

[LordNeilLord]

Hey @Himal

Can you give me an example of the output...just the first line of data will be enough.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[Himal]

Thanks, @Bharti. I got it.