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	alice.smith@example.com
2	Bob Brown	bob.brown@sample.org
3	Charlie Lee	charlie.lee@test.edu
4	Daisy Adams	daisy.adams@company.com

---

Sample Configuration

---

Sample Output

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

---