Joining List of List

amoltalap · July 12, 2017, 12:01am

Hi

I could get the data as List in below format by parsing the XML using my code in this email at the bottom.

list: List[Any] = List(List(Comment(Title1.1,Descript1.1,)), List(Author(Suresh,
2017-01-11,), Author(Amol,2017-07-17,)), List(Publisher(Vishal,2016-01-11,), Pub
lisher(Arindam,2015-01-11,)))

Can you please help joining the data set from List to get data in a format as below.

Code below:
import scala.xml._
import scala.collection.mutable.ListBuffer
import scala.collection.mutable._

def parseMyXML(xml:String) = {
val myXml = scala.xml.XML.loadString(xml)
val comments_comment = (myXml \ “Comments” \ “Comment”)
val data = comments_comment.map{x=>(x.child(0).text
,x.child(1).text)}
//val data = comments_comment.map{x=>readXML (x)}
case class Comment(title:String,description:String,full_description:String)
case class Author(author_name:String,author_date:String,author_misstag:String)
case class Publisher(publisher_name:String,publisher_date:String,publisher_misstag:String)

	var data_map = Map[String, Any]()
	var data_list = new ListBuffer[Any]()
	
	for(comment <- comments_comment)
	{
		var title = (comment \\ "Title").text.trim
		var descr = (comment \\ "Description").text.trim
		var fdescr = (comment \\ "Full_Description").text.trim	//data missing tag
		
		var comment_list = new ListBuffer[Comment]()
		comment_list += Comment(title,descr,fdescr)
		data_map.put("comments", comment_list.toList)
		data_list += comment_list.toList
		
		var child1 = (comment \ "Authors" \ "Author")
		var author_list = new ListBuffer[Author]()
		for(author <- child1)
		{
			val author_name = (author \\ "Name").text.trim
			val author_date = (author \\ "Date_of_Writing").text.trim
			val author_misstag = (author \\ "MissingTag").text.trim
			author_list += Author(author_name,author_date,author_misstag)
		}
		println("No. of nodes " +  (child1 \ "_").length)
		//Need to change this validation lengths to make fool proof
		if((child1 \ "_").length > 0 && author_list.length > 0) {
			data_map.put("authors",author_list.toList)
		}
		data_list += author_list.toList
		
		var child2 = (comment \ "Publishers" \ "Publisher")
		var publisher_list = new ListBuffer[Publisher]()

		for(publisher <- child2)
		{
			val publisher_name = (publisher \\ "Name").text.trim
			val publisher_date = (publisher \\ "Date_of_Publish").text.trim
			val publisher_misstag = (publisher \\ "MissingTag").text.trim
			publisher_list += Publisher(publisher_name,publisher_date,publisher_misstag)
		}
		data_map.put("publishers",publisher_list.toList)
		data_list += publisher_list.toList
		println("")
		println("data_map is " + data_map)
		println("")
		println("data_list is " + data_list.toList)
		println("")
	}
	//data_map
	data_list.toList

}

val xml1=“Title1.1Descript1.1Suresh<Date_of_Writing>2017-01-11 </Date_of_Writing>Amol<Date_of_Writing>2017-07-17 </Date_of_Writing>Vishal<Date_of_Publish>2016-01-11 </Date_of_Publish>Arindam<Date_of_Publish>2015-01-11 </Date_of_Publish>”

val list = parseMyXML(xml1)
println("")
list.foreach(println)

Regards,
Amol