Ask Your Question

How to use FILTERXML to have all the mapped items of an XML source?

asked 2017-02-02 13:04:33 +0200

Andrea Borruso gravatar image

Hi, when I use FILTERXML I obtain only the first result.

Look in example at:


How to obtain all mapped items?

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-02-02 15:32:32 +0200

Ratslinger gravatar image

updated 2017-02-02 20:12:19 +0200

This must be set as an array. Select the number of cells for returned information, open Function Wizard, enter your formula as stated in your question and turn on Array (lower left corner):

image description

Select OK will produce:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-02 13:04:33 +0200

Seen: 536 times

Last updated: Feb 02 '17