The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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?
The error was resolved by deleting the rows in green and then changing the red I#[?????] to I#[*]:
Final:
2 Replies
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 IfThe error was resolved by deleting the rows in green and then changing the red I#[?????] to I#[*]:
Final:
