Index MII Row

[Former Member]

Hi All,

I am using an RFC call 'RFC_READ_TABLE'. This returns the data in a concatenated string delimited by a character you specify. This isn't a problem since I used the String list to XML Parser action. The problem is this returns each column of data as a row in the 'Rowsets Rowset Row' Mii XML schema. So my question is; is there an easy way to say I want the value at row 12 without looping through and counting 12 rows?

Jasper

[jcgood25 · Accepted solution]

String_List_To_Xml_Parser_0.Output{/Rowsets/Rowset/Row[12]/Item}

If the number needs to be dynamic then it could look like (where "RowNo" is a local integer propery you set in logic somewhere):

String_List_To_Xml_Parser_0.Output{/Rowsets/Rowset/Row[#Local.RowNo#]/Item}

String_List_To_Xml_Parser_0.Output{/Rowsets/Rowset/Row[position() = last()]/Item}

would give you the last item.

[Former Member]

It looks like the forum auto-marked-up Jeremy's text into URLs. In the first example, the syntax to identify a particular row (like row 12) is to put the argument (e.g. 12) in square brackets. This leverages standard XPath.

Edited by: Jeremy Good on Oct 27, 2010 9:36 PM

Thanks Dave - I marked it as code so the forum markup didn't confuse people.