I have an xml that contains employee id and more than one relationship viz. MGR_ONE, MGR_TWO etc. Since there is only one employeeid, the load deletes one of the records and shows ONLY one relationship for each employeeid.
Is it possible to load all the records corresponding to each employeeid.
Directory; // Start of [eg.xml] LOAD statements hello1: LOAD [HELLOIdentifier/EmpID] as [EmpID], [HELLOIdentifier/EmpName] as [Emp Name], [HELLOIdentifier/HELLOIdScheme] as [Scheme], [relation/relationScheme] as Relation, [relation/firstName] as Firstname, [relation/lastName] as LastName, [relation/HELLOIdentifier/EmpID] as MgrID FROM ..\eg.xml (XmlSimple, Table is [hello/HELLOSet/HELLO]);