Originally posted by: vijji_WTX

Hi All,
I am using WTX 8.1 and we have one map which processes Delimitor file line by line. Recently this map failed because of 10th record error and 9 records were processed. We now have to give fix like..Map should skip the INVALID records and process only VALID records. i.e in 10 records...if 5 and 8 records are INVALID , Map should ignore/skip this records and should process rest of the records. I tried to get this uysing ISERROR or ContainsErrors etc functions. Problem here is ..Map processing up to VALID records and ends at INVALID records.

Record(s)=if ( iserror(record) , "Bad->"+TEXT(record), "OK"+TEXT(record))

Above funtion is just working for VALID records. I need a solution like below format( which was from WTX documents).
Bad --> MK-19309,,369.43,417,W100
Ok --> KL-20349,PCMCIA Network Adaptor,174.82,29,N300
Ok --> WP-37679,AC Adaptor,39.48,245,E100
Bad --> IL-39890,8MB Memory PCMCIA,390.48,0,S100

Final solution is....Map should Ignore INVALID records and process only VALID records
INVALID record means....If Date value expected is 23-MAR-2008....and i gave 23-MAR-22233. So this kind of record should ignore

Hope i made you understand my problem.

Advanced New yeat Wishes 2010 to All..

regards
Vijji
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

You need to use restart attribute at your group level in the TT & then a reject function to filter out invalid records &
continue map processing.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: vijji_WTX

Hi Ask,

I used restart attribute at group level and i got some positive result. In my type tree i have 15 items and there may be chance that..any of this value can be INVALID in pnput file. If i give Restart attribute for all the items..do it is a performance issue from Map side ?? or i can ignore this.

Please advice me.

Thanks & Regards
Vijay
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

The map sample that I attached was in 8.2 & would not open in lower versions...I dont have 8.1 on my box.

The restart needs to be at the group level (which comprises of 15 elements in your case) which constitutes your ip record. Plz go through the help
if you have any doubts about usage.

Regards
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

this demonstrates what i meant in my earlier post...
its in 8.2 though.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: vijji_WTX

Hi ASK,

Wish you a happy new year and Thanks a lot for your time and info. I am able to extract the TT and Map but unable to open in TT designer and Map designer. I am using WTX 8.1 version. I dont know the reason. I just tried to put my TT,map and input details. Here i attached Valid input file and Map is working fine. In case 2 or 3 record is INVALID , Map should process rest of the records and ignore the INVALID records.( I will log this INVALID record info. in to Database).

I appreciate your kind time on this and Thanks in advance !!

regards,
Vijay
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender