Convert column that contains a list of dictionaries into individual columns

[alowe]

Hi All - looking for help converting the example below input into the output dynamically as this will need to be done across a variety of fields. Any ideas? Thanks!

Input (1 field):

ColumnName1

[{'id': 123456, 'name': 'Example Name', 'parent_id': None, 'parent_department_external_id': None, 'child_ids': [], 'child_department_external_ids': [], 'external_id': ''}]

Output (7 fields):

id	name	parent_id	parent_department_external_id	child_ids	child_department_external_ids	external_id
123456	Example Name	None	None

[atcodedog05]

Hi @alowe 

This looks like JSON can you provide sample data with more childs in the dictionary

'child_department_external_ids': []

Happy to help : )

[Qiu]

@alowe 
If we just want to do parsing. 😁