OUT port partial match IN port using wildcard

CloverDX Platform
1

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 :frowning:

I have multiple out that starts with the word “skip” and I want to set all of them to value ‘Y’.

2

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.