Actually I have a situation where based on 3 attributes(jobCategory ,jobFamily ,Title) I have to choose a role from the mapping table. I have concatenated the 3 attributes using ":" as a delimiter. Now any of the 3 attributes can contain * as value which means irrespective of any value it will get the role (ex. PATIENT CARE-NON-RN:TECHNICIANS:*). to achieve this I have tried the following:
So you build a string in your first token, that includes Regex.
Then you want to use that inside a Map token as the src column.
I think Lothar's approach can be adapted to your need.
Get the XML of the table into a nodeset, then use his es:matches() call to find the right row, and then get the column back you are looking for.
You do know, that if you have a mapping table, where the Src value returns more than one, you get a nodeset back. Then you could look at those values, if it helps? (Basically make the variable you store it into a nodeset and then you get a nodeset of values back).