Flatten Json Object

Description

Splits the rows of the column containing the JSON data into multiple columns.

Input

Data only

Output

Transformed data

Configuration Fields

Columns Allows input of multiple column names.

Sample Input

employee_id	name	age	contact
E001	John Doe	32	{“email”:“[email protected]”, “phone”:“+1-555-1234”, “}
E002	Jane Smith	28	{“email”:“[email protected]”, “phone”:“+1-555-5678”}
E003	Ali Khan	40	{“email”:“[email protected]”, “phone”:“+1-555-9876”}
E004	Maria Gonzalez	35	{“email”:“[email protected]”, “phone”:“+1-555-2468”}
E005	Rahul Sharma	30	{“email”:“[email protected]”, “phone”:“+1-555-7890”}

Sample Configuration

Sample Output

employee_id	name	age	contact_info	Contact_email	Contact_phone
E001	John Doe	32	{“email”:“[email protected]”, “phone”:“+1-555-1234”}	[email protected]	+1-555-1234
E002	Jane Smith	28	{“email”:“[email protected]”, “phone”:“+1-555-5678”}	[email protected]	+1-555-5678
E003	Ali Khan	40	{“email”:“[email protected]”, “phone”:“+1-555-9876”, }	[email protected]	+1-555-9876
E004	Maria Gonzalez	35	{“email”:“[email protected]”, “phone”:“+1-555-2468”}	[email protected]	+1-555-2468
E005	Rahul Sharma	30	{“email”:“[email protected]”, “phone”:“+1-555-7890”}	[email protected]	+1-555-7890