XMLTABLE -- WORK WITH NESTED XML DATA

I am trying to convert the Nested XML File data and load into a table ( Headers and Line item Data) , As HANA does not have the supporing data type XMLPATH could not hold the nested tag data to use as table later .Here is the sample data

'<resultset> <row> <ID>1</ID> <COUNTRY>India</COUNTRY> <DATEJOINED>2017-08-11</DATEJOINED> <LineItems> <LineItem> <Number>1</Number> </LineItem> <LineItem> <Number>2</Number> </LineItem> <LineItem> <Number>3</Number> </LineItem> <LineItem> <Number>4</Number> <Number1>5</Number1> </LineItem> </LineItems> </row> <row> <ID>2</ID> <COUNTRY>India</COUNTRY> <DATEJOINED>2017-08-11</DATEJOINED> <LineItems> <LineItem> <Number>6</Number> </LineItem> <LineItem> <Number>7</Number> </LineItem> <LineItem> <Number>8</Number> </LineItem> <LineItem> <Number>9</Number> <Number1>10</Number1> </LineItem> </LineItems> </row> </resultset>'

Any thoughts / solutions how to work with nested XML Data