Forum Discussion
Usha_Kodali
15 years agoFrequent Contributor
Hi Ole,
I am getting values using XML Datasource.
But the result looks likes this.
ID SpotID
4
5
1
1
But my expected result should be
ID SpotID
4 1
5 1
How to achieve the above result?
my rowpath expression is
declare namespace aetgt='http://musicchoice.com/services/games';
//aetgt:GetSpotListsResult/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']/../..,
//aetgt:GetSpotListsResponse/aetgt:GetSpotListsResult[1]/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']
column path expression is
aetgt: ID/text()
aetgt: SpotID/text()
I am getting values using XML Datasource.
But the result looks likes this.
ID SpotID
4
5
1
1
But my expected result should be
ID SpotID
4 1
5 1
How to achieve the above result?
my rowpath expression is
declare namespace aetgt='http://musicchoice.com/services/games';
//aetgt:GetSpotListsResult/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']/../..,
//aetgt:GetSpotListsResponse/aetgt:GetSpotListsResult[1]/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']
column path expression is
aetgt: ID/text()
aetgt: SpotID/text()