Issue in XML transformation

Hi Team,

I am trying to do some XML transformation and I’m stuck. Here goes the problem description.

I have uploaded one xml file with .txt extention and uploading .xml file is not allowed. I have masked data!

Subhasree.txt (1.7 KB)
In this file, we have got CalculatedCurrency tag where we have multiple sub tags and also this CalculatedCurrency occurs multiple times in the file means CalculatedCurrency can have multiple Amount, Currency and VatAmount. But I need to pick up only that Currency which belongs to
BranchCurrency (another tag in the file) and of course corresponding Amount and VatAmount for that Currency.

Please help.

Thanks & Regards,
Subhasree