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”:“john.doe@example.com”, “phone”:“+1-555-1234”, “}
E002	Jane Smith	28	{“email”:“jane.smith@example.com”, “phone”:“+1-555-5678”}
E003	Ali Khan	40	{“email”:“ali.khan@example.com”, “phone”:“+1-555-9876”}
E004	Maria Gonzalez	35	{“email”:“maria.gonzalez@example.com”, “phone”:“+1-555-2468”}
E005	Rahul Sharma	30	{“email”:“rahul.sharma@example.com”, “phone”:“+1-555-7890”}

Sample Configuration

Sample Output

employee_id	name	age	contact_info	Contact_email	Contact_phone
E001	John Doe	32	{“email”:“john.doe@example.com”, “phone”:“+1-555-1234”}	john.doe@example.com	+1-555-1234
E002	Jane Smith	28	{“email”:“jane.smith@example.com”, “phone”:“+1-555-5678”}	jane.smith@example.com	+1-555-5678
E003	Ali Khan	40	{“email”:“ali.khan@example.com”, “phone”:“+1-555-9876”, }	ali.khan@example.com	+1-555-9876
E004	Maria Gonzalez	35	{“email”:“maria.gonzalez@example.com”, “phone”:“+1-555-2468”}	maria.gonzalez@example.com	+1-555-2468
E005	Rahul Sharma	30	{“email”:“rahul.sharma@example.com”, “phone”:“+1-555-7890”}	rahul.sharma@example.com	+1-555-7890