Originally posted by: ICS_User_Shane

Hey Guys,

I'm new to WTX so bear with me.

I have a mapping rule within a functional map:

If i remove the first part of the rule: FILLRIGHT(ASW_ID, " ", 4)  I get that part of the output.  If i add in the remainder of the rule, i dont return anything for that portion.  if i remove the first part of of the rule, i get the second part.  If i change the second part to a literal and remove the LOOKUP, the whole rule works perfectly.

Is there something about WTC that you cant use a LOOKUP and COncatenate within the same rule?  I'm on WTX 8.1.

Originally posted by: paul.brett

I think you'll find that you can't use LOOKUP() and MEMBER() together, as they are series consuming functions.

Perhaps you could do something like this:

=F_ConcatStuff(FILLRIGHT(ASW_ID, " ", 4)  ,  FILLRIGHT(IF(MEMBER(EntityIDCd Element:N1 Segment:LoopN1_1:Tran850, {"ST", "BS", "SO"}),  IDCd Element:IDCd MComposite:N1 Segment:LoopN1_1:Tran850  ,  BusRuleVAL  ,  N1 Segment:LoopN1_1:Tran850)

...and then do the LOOKUP() inside the functional map (using input cards 3 and 4):

=In1+"-"+In2+LOOKUP(IDCd Element:IDCd MComposite:In4, EntityIDCd Element:In14 = In3)

Thank-you.

Paul

Follow me on Twitter

Originally posted by: Arun Ramamurthy

Also when using several series consuming functions like Lookups, extracts in the same rule  , it could sometimes lead to a data binding issue if the rule is pointing to the same top level group or element. In the above example , it could be at the level " N1 Segment:LoopN1_1:Tran850 " . As Paul indicated using a functional map approach should help.