Originally posted by: SystemAdmin

Scenario: A legacy client file needs to transformed into a Client specific.
1]Before being transformed,the legacy file needs to reference a Cross-reference Client master file.

2]If the Client code in the legacy file exists in the Client Master file then only it needs to get transformed otherwise it needs to be treated as invalid record and mapped to a another output card having the set of invalid data.

Probable Solution: Using Lookup only the particular field can be ignored.How do we ignore the whole record and re-direct it to another output card having the invalid data...
Shall we filter the records with the Lookup condition at the begining of the output cards and called for a subsequent functional map for the actual transformation whether valid or invalid data to their respective ouput cards.
Thanks,
Jignesh
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: LaurentB

Hi Jignesh,

I usually treat this using a 3 steps scenario.

In an output card #1, which goes to Sink, I use an ad-hoc type tree which handles :
- a copy of an input record (usually in a blob, except if I need further processing in step 3)
- a new output record, in which I map the input record format to the output record format, including the LOOKUP. If the LOOKUP fails, I like to write a "dummy" keyword in place of the expected value (let's say something like ####, that is easily recognizable and cannot be part of the data)
- a status field, which gets "OK" if LOOKUP succeeded, and "KO" otherwise (so KO if field was maped to ####)

In output card #2, which is the actual output, it is quite easy to EXTRACT all the records from card #1 which have OK as the status. Since card #2 uses the same type tree and type as the output record of card #1, no functional map is needed there

In output card #3, using whatever format is needed (if possible a set of blobs), you then can EXTRACT the records which have KO as the status.

Hope this helps
Laurent
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

thanks.....i'll prefer this....
Thanks,
Jignesh
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks for ur reply;
I have two output cards.In output card#1 I have a recordstatus field which has I for invalid and V for valid values based on valid client and branch codes.
When I have to assign the value to recordstatus....how do we write in the rule bar....
something like this....."IF Branch_Code = 0 OR Client=0 then "I" else "V"
Thanks,
Jignesh
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

=IF (Branch_Code = 0 | Client=0,"I" , "V")
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

thx very much....
Thanks,
Jignesh
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender