XPATH to extract collection elements

Hello,

I am trying to extract array of XML elements using XPATH , but XPATH allows to retrieve only 1 element at a time , though I see it has option multiple rows . For example my XML has

<locales>
    <locale> en_us</locale>
    <locale>e_uk </locale>
    <locale>fr_ch </locale>
</locales>

In XPATH giving /root/locales allows return of node fragment which is again XML and for String option , it concatenates the values .

I would like retrieve the locale values as individual rows .

Appreciate help on the above
Regards,
Nivedita

Hi @nivedita_dixit

You were going in the right direction, the String + Mulitple Rows option is the way to go :slight_smile:

Query settings:

image

2 Likes

Thanks @ArjenEX , I realized it after posting .

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.