Hi @Sameer Khalid​ ,

check this notebook on how to work with nested json : https://learn.microsoft.com/en-us/azure/databricks/kb/_static/notebooks/scala/nested-json-to-datafra...

what you need to look at is how to work with:

• Struct - col_name.*
• arrays - explode

I might be able to look more closely to the logic of the flatten function later.