Originally posted by: repanzer
The code looks fine actually.
Some different variants may be something like;
=IF (LocFunctCdQual'r Element:.:Group3 IN PAXLST_FD05B_Inbound_Partner_Msg = 87 &
LOOKUP ( Country Field:.:AirportLookupFile , Code Field:AirportLookupFile = LocNameCd Element:.:Group3:PAXLST_FD05B_Inbound_Partner_Msg ) = "USA" , "E" , "P" ))
But if you're not getting the expected results from the look up, I would probably comment out my rule, then just to be absolutely sure the basics are correct, use this statement;
EXTRACT(Country Field:.:AirportLookupFile, Code Field:AirportLookupFile="abc") where abc is the code in the look up for USA. Don't use the data from the input.
My assumption is that the look up table look like this;
CODE FIELD, COUNTRY FIELD
abc,USA
If that returns USA, then I would keep changing the rule back to what you originally had, piece by piece, like;
EXTRACT(Country Field:.:AirportLookupFile, Code Field:AirportLookupFile=LocNameCd Element:.:Group3:PAXLST_FD05B_Inbound_Partner_Msg )
Then if that doesn’t return USA, it’s not using the correct LocNameCd Element:.:Group3:PAXLST_FD05B_Inbound_Partner_Msg you were expecting, but if it does return USA, the change the EXTRACT back to LOOKUP.
Basically, make the rule as simple as possible and get it to work at that level, then keep changing the rule to what you want, and when you don’t get the results you expect, the last change is where you’re problem is.
Know what I mean?
#DataExchange#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender