I am trying to do manual XSLT mapping. How do you map 3 fields into one ID? (ProjectRevenue/IDs/ID). The instruction is with concatenation. Any example would be awesome.

Hi Benito,

Don't really have an example right now. But a simple google search will give you a lot of them.

Here's one -
https://stackoverflow.com/questions/12247922/how-to-concatenate-data-in-xsl

I guess that should get you going.

Thank you Bushan. I will take a look.

No problems. If possible do post your solution as a reference too. All the best!

This one worked for me for Hours and Expenses:
<ID>
<xsl:value-of select="concat(3,'_',/ProcessPCSProjectCSV/DataArea/PCSProjectCSV/Employee,'_',/ProcessPCSProjectCSV/DataArea/PCSProjectCSV/Year,'_',/ProcessPCSProjectCSV/DataArea/PCSProjectCSV/Period)"/>
</ID>
The fields are separated by '_' (with single quotes).