Wildcard

David Paras

• April 13, 2012 21:08

Can you use a wildcard in the when condition? If so, what character is the wildcard?

Example:
WHEN CONDITION{Error= 'ERR%'} VALUE=['E' ] OTHERWISE VALUE=['S']

0

• 

  David Paras

  • April 13, 2012 21:08

  In Data mapper Wild card is not supported in When condition. But there is an alternate approach that can be used for this. We have given an example for your scenario below that uses contains function:
  
  WHEN CONDITION{Error= contains($Input_SourceSchema/Root/Record/Error ,'ERR' ) } VALUE=[ 'E'] OTHERWISE VALUE=[ 'S' ]
  
  Similarly, you can also use "Starts-with" function here.

  0

Please sign in to leave a comment.