Split Email Address

Description

This activity splits the specified column containing the email address into two parts in two different columns- the local part and the domain part.

Input

Data only

Output

Transformed Data

---

Configuration Fields

1. Column Name Allows single select, must contain the email address.
2. Local part column The column name where the local part of the email address will be inserted.
3. Domain column The column name where the domain part of the email address will be inserted.

---

Sample Input

id	name	email
1	Alice Smith	[email protected]
2	Bob Brown	[email protected]
3	Charlie Lee	[email protected]
4	Daisy Adams	[email protected]

---

Sample Configuration

---

Sample Output

id	name	email	local_part	domain_part
1	Alice Smith	[email protected]	alice.smith	example.com
2	Bob Brown	[email protected]	bob.brown	sample.org
3	Charlie Lee	[email protected]	charlie.lee	test.edu
4	Daisy Adams	[email protected]	daisy.adams	company.com

---