I have a simple XML file that I would like to import into the CDS using the New Entity from Data. I locate the XML file which is on my companies Sharepoint and it loads it and I can see 4 columns (Name, Namespace, Value and Attributes). Below those headers I have 1 line of information, Detail, nothing in Namespace, then [Table] in Value and [Table] in Attributes. If i click the Value [Table] link i now see the same column headers as before but I see the word data in the Name column and there are 43 lines (which is the number of employees). If I click the [Table] in the Value column again i finally get to the data that I need, 3 bits of information showing employee Clock, Name and In-Out.
How do I choose the right primary key, it should be the Clock and all I want is those 3 pieces of data
