Merging two columns into one in a web service result set   

I'm calling a webservice which returns data that looks something like this:

<result>
<accountNumber>12345</accountNumber>
<value>5000.00</value>
<currencyCode>USD</currencyCode>
...
</result>

When I'm displaying the results to the user I want to merge the value and currencyCode into a single column. I've tried using a Data Column Modifier to set a very small size on the currencyCode value instead of actually merging. This is close, but I need a right-aligned column header so this doesn't quite looks right.

Just wondering what the best approach is to merge two columns into one.

Thanks,

Dave

Thanks for the reply. That almost solves my problem, but there is still one small detail. The value I wanted to display is to be formatted as a currency. I was using a Data Field Modifier to apply a NumberFormat to this value, but this does not take effect when I use this technique. Any recommendation as to how to best solve this problem? Do I have to write a custom method to apply the format and append the currency code? If so, how do I call a format function from a method? Or, is there a better approach?

Thanks,

Dave

Shoot. I missed an open curly brace

${Variables/RowLoopVar/val1} at $${Variables/RowLoopVar/val2}