Value from last transaction in XML

OL Connect Professional DataMapper
1

Hi,
I would like to extract the payDate value under payments\payList tag from below XML.
However, some records will have the multiple payList being passing in and we just want the value from last payList.
Besides, some records will have the possibility of not having any record of payments.

Please advise.

image

2

Extract the field as you would want a single field, then change the index on payList element in XPath expression to last(), eg.

./payments[1]/payList[last()]/payDate[1]