Hi, I am new to Spark. I have a text filewith below structure.
(employeeID: Int, Name: String, ProjectDetails:JsonObject{[{ProjectName, Description, Duriation, Role}]})Eg:(123456, Employee1, {“ProjectDetails”:[ {“ProjectName”: “Web Develoement”, “Description” : “Online Sales website”,“Duration” : “6 Months” , “Role” : “Developer”} { “ProjectName”: “Spark Develoement”, “Description” : “Online SalesAnalysis”, “Duration” : “6 Months” , “Role” : “Data Engineer”} { “ProjectName”: “Scala Training”, “Description” : “Training”,“Duration” : “1 Month” } ] } Could someone help me to parse & flatten the record asbelow dataframe using scala? employeeID,Name, ProjectName, Description, Duration, Role123456, Employee1, Web Develoement, Online Sales website, 6Months , Developer123456, Employee1, Spark Develoement, Online Sales Analysis,6 Months, Data Engineer123456, Employee1, Scala Training, Training, 1 Month, null Thank you in advance. Regards,Raja