Hi,
I have 3 records Rec_A, Rec_B, Rec_C_D and each of this record having common strcuture of fields but with different occurances.
Rec_A -- EMPNO 1:1
JNDate 0:1
Dept 1:1
Rec_B -- EMPNO 1:1
JNDate 1:1
Dept 1:1
Rec_C_D -- EMPNO 1:1
JNDate 0:1
Dept 1:1
It is a Asterik(*) separated delimited file and end separator is New Line.
Depending on the Dept field, the record has to processed.
Ex: If the Dept value is C, then it has to process Rec_C_D and if Dept value is B, it has to process Rec_B Vice versa.
In Configuration I specified the FCC Parameters as follows :
*KeyFieldName : Dept*
Rec_A.fieldSeparator : *
Rec_A.endSeparatot : 'nl'
Rec_A.fieldNames: EMPNO,JNDate,Dept
Rec_A.keyFieldName: A
Similarly defined for Rec_B and Rec_C_D as well.
I gave my input file as follows :
12320080102A
345* *B
789* *A
14320080102C
Its reading only the two records ( First and last one) as I gave all the three fields in the input file.
If I miss any of the filed (although it is optional) its not processing that record.
Please give me some pointers to overcome this issue.
Regards,
Babu