Originally posted by: raj1

i have 2 input files.first file consists of accountnumber and date.second file also consists of account number and date.i have to get account numbers and dates of those records which are in inputfile 1 and not in inputfile 2.When i am trying with extract and not condition in fmap i am getting the cartesian product.i.e, I am getting duplicate records.Should i need to use control-break for this?If there is any simpler way to get this please suggest me.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

this can be done using Member function. I am posting a sample scenario using the same where in we dont need any control break etc.

As per the sample scenario, Rec2 from file 1 will be the output as its not present in file 2.

I hope this resolves ur question.

Thanks...
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: raj1

Thanks man,good logic.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: raj1

Now the inputfile1 consists of not only account number and date.It also consists of customer name.The inputfile2 still consists of only account number and date.In this case i cannot use a member function.Can you help me out in solving this issue.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: janhess

If the file is sorted you can use SEARCHUP otherwise use LOOKUP. SEARCHUP would be much faster though. You can combine this with the PRESENT/ABSENT functions.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: raj1

janhess,
I tried like that.But i am getting all records.I am attaching the map.please see it and suggest me the change.Thanks
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

This rule works if you correct the data in samp1.txt (date field wrong size in many records)
=if(absent(lookup(record:BOT_Parser_Recon,BAN:record:BOT_Validation_Recon=BAN:record:BOT_Parser_Recon)),
fmap(record:BOT_Validation_Recon))
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

Your input file samp1.txt is still wrong. Check your trace file. It says
INPUT 2 exists (737 bytes) but has no content
There is a tab character in the first record.
Check your results before posting.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: raj1

janhess,
I have done the changes for input data and used the rule you have told me,but still i am getting all the records.pl. see the attached map and suggest me.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: janhess

Your input file samp1.txt is still wrong. Check your trace file. It says
INPUT 2 exists (737 bytes) but has no content
There is a tab character in the first record.
Check your results before posting.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: raj1

Janhess,
you are outstanding.Yes,I was little careless in posting my last reply.Your logic is working perfect.Thanks a lot.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender