how to do fixed length conversion if there is not keyfield value in fcc

[Former Member]

Hi,

I have my input file in this structure.

re898372487(Header record)

2fggfd grtg gty ry 545 rt esef

1dger gerg hhr rt hrt hf tdfg (all three rows are data records)

1dger gerg hhr rt hrt hf tdfg

eredbhfggdfhgfh(Footer record)

In the above example it is a fixed length file i can identify my header and footer records with their respective key field values.But for the data record who occurance is ' * ' there are two key field values namely ' 2' and ' 1 '.How can give the key field value in this case.

Thanks and Regards,

Bhargav

[Former Member]

Hi

i think there will be always single key value for all the data records for the header, and for the footer. please clarify for your test file.

ifyou will use the single key for all the data records then you can use the following content conversion parameters in the sender communication channel.

RECORD.fieldSeparator :,

RECORD.fieldNames :KEY,FNAME,LNAME,AGE

RECORD.keyFieldValue :1

DETAIL.fieldSeparatr :,

DETAIL.fieldNames :KEY,SALARY,EMPID

DETAIL.fieldNames :2

Note:these parameters are accoding to the structure given below.

suppose you have a structure like as below

data (0..unbounded)

record (0..unbounded)

key (1..1)

fname (1..1)

lname (1..1)

age (1..1)

detail (0..unbounded)

key (1..1)

salary (1..1)

empid (1..1)

and the input file will look like as below

1,aaa,bbb,23

2,12000,10838

1,ccc,ddd,23

2,13000,10830

if you still have the problem please reply me back

Thanks

Rinku