Transformation Error of Composite Mapping Type when using "?"

Question

I need some assistance. The following error is displayed during the Load and Transform WF step (v9.0.1.17608):

The use of "?" and "*" is discussed in the Design and Reference guide as per below:

Requirement: There is an entity with 5 characters with suffix _ICI30 that needs to map to C4500 if the IC has 5 characters, and another with 9 characters with suffix _ICI30 that needs to map to C3000 if the IC has 5 characters.

How do I define the rule expression if E#[?????_ICI30]:I#[?????] and E#[?????????_ICI30]:I#[?????] are incorrect?

Z11G11 · Accepted Answer

The error was resolved by deleting the rows in green and then changing the red I#[?????] to I#[*]:  Final:

MarcusH · Answer

I get the same error message on V8.4. That looks like a bug. I suggest you contact support. In the meantime you could create a Complex Expression on a Mask * map rule something like this:

Dim thisEnt As String = args.GetSource("E#")
Dim thisIC As String = args.GetSource("I#")

If thisEnt.EndsWith("_IC130") AndAlso thisIC.Length = 5 Then
	If thisEnt.Length = 11 Then
		Return "C4500"
	ElseIf thisEnt.Length = 15 Then
		Return "C3000"
	End If
End If

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded