Originally posted by: SystemAdmin

hi.. i am passing 2 condition into extract. bUt want to trigger one condition if other condition Not met..
here is My condition..
=F_CreateRec( 813_Record:Census_Group Record:AdecensBatch:EmpIn, EITHER(EXTRACT( 800_Record:Census_Group Record:AdecensBatch:EmpIn, (SSN Field:800_Record:Census_Group Record:AdecensBatch:EmpIn=SSN Field:813_SSNgroup:813_Record:Census_Group Record:AdecensBatch:EmpIn&Sequence Field:800_Record:Census_Group Record:AdecensBatch:EmpIn="01")|Transaction_code Field:813_SSNgroup:813_Record:Census_Group Record:AdecensBatch:EmpIn!="813"),"0000"))

this condition match when i have 813 and 800 together for i want to pass 800record even if 813 Not there..how can i do that..?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

If I understand you correctly, you might try something like the following:

=F_CreateRec(EITHER(813_Record,""),
EITHER(EXTRACT(800_Record, etc.) )

or

=IF(PRESENT(813_Record),
F_CreateRec(813_Record, EITHER(EXTRACT(800_Record, etc.),
F_CreateRec2(EITHER(EXTRACT(800_Record, etc.) )
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

in first condition..again 800 is not passing..but for second condition do i need to creaet separate F_CreateRec2 .. if so does that will have 2 cards...?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Yes, for the second option I suggested, you need to create an additional functional map. It will have only one output card for the 800 Record.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

i am getting Output But that it seems like 813 type is repeat twise

is this ok..?

=IF(PRESENT( 813_Record:Census_Group Record:AdecensBatch:EmpIn ),
F_CreateRec( 813_Record:Census_Group Record:AdecensBatch:EmpIn, EITHER(EXTRACT( 800_Record:Census_Group Record:AdecensBatch:EmpIn, tc,"0000")),
F_CreateRec2(EITHER(EXTRACT( 800_Record:Census_Group Record:AdecensBatch:EmpIn,tc),"0000")))

this causing me to trigger excute 2 813 ..!!
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

It looks correct. The only way this rule should trigger twice is if you have 2 813 records or 2 800 records in the input. What your output looks like depends on how you map the results of the functional map executions.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender