Databricks

Gopal_Sir · 06-08-2022

I have a nested struct , where on of the field is a string , it looks something like this ....string = "[{\"to_loc\":\"6183\",\"to_loc_type\":\"S\",\"qty_allocated\":\"18\"},{\"to_loc\":\"6137\",\"to_loc_type\":\"S\",\"qty_allocated\":\"9\"},{\"to_lo...

Gopal_Sir · 06-09-2022

I've marked my comment as best . Does anything else need to be done ?

Gopal_Sir · 06-09-2022

Ok , so I got it working . Call the from_json() function with string column as input and the schema at second parameter . It will convert it into struct .

Databricks

User Stats

User Activity

How to convert a string column to Array of Struct ?

Re: How to convert a string column to Array of Struct ?

Re: How to convert a string column to Array of Struct ?