Forum Discussion

Z11G11's avatar
Z11G11
New Contributor II
20 days ago
Solved

Transformation Error of Composite Mapping Type when using "?"

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? 

 

 

Import
Transformation
  • Z11G11's avatar
    Z11G11
    1 day ago

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

     Final: 

     

2 Replies

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    17 days ago

    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

     

  • Z11G11's avatar
    Z11G11
    New Contributor II
    1 day ago

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

     Final: