OUT port partial match IN port using wildcard

yichuansancun

• November 24, 2014 00:00

• Answered

Follow

I know I can do this in Clover:

$out.0.* = $in.0.*

However, how can I do this in Clover:

$out.0.skip* = "Y"

I tried and it is giving me error :(

I have multiple out that starts with the word "skip" and I want to set all of them to value 'Y'.

• 

  imriskal

  • November 25, 2014 13:24

  0

  Comment actions Permalink

  Hi,
  
  You can use this CTL code:

  function integer transform() {
  	
  	$out.0.* = $in.0.*;
  	
  	for (integer i = 0; i < length($in.0); i++) {
  		if (substring(getFieldName($in.0, i), 0, 4) == "skip") {
  			setStringValue($out.0, i, "Y");
  		}
  	}
  
  	return ALL;
  }

  In CloverETL 4.0 substring can be replaced by more convenient startsWith function.

Please sign in to leave a comment.