Key Field in FCC

[Former Member]

Hi All,

I have a file structure like follows:

Row

Row

Row

.

.

.

Footer

In Row i don't have any key field(I am assuming Key field has to have same value in all corresponding records)

however in Footer i have first field which has value 'FT'. So i can say that it is my key field(Field name "Type").

How can i configure it in FCC?

Currently i have set it as:

Footer.keyFieldValue "FT"

Footer.keyFieldName "Type"

It is not working.

Thanks,

Atul.

[VijayKonam]

In row also you must have a key field. Otherwise you will not be able to complete the FCC parameters.

VJ

[Former Member]

Hi VJ,

Thanks for ur reply.

Is there any other alternative for this?

Regards,

Atul

[Former Member]

Hi,

I guess this will give you some idea.

Content Conversion ( The Key Field Problem )

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Regards,

Sarvesh

[Former Member]

Hi Sarvesh,

Thanks for ur reply.

But my problem is i don't have keyfield in Row.

I only have keyfield in Trailer record.

I am struggling with how can i access the one record without key field and other with keyfield?

Regards.

[Former Member]

Atul,

I had a similar issue and couldn't find a way to make it work in the FCC so I created an XSLT mapping. The mapping cycles through the records and I pack together the records I need in the structure I want.

- Emmett

[Former Member]

Hi Emmett,

Thanks for ur reply.

Can u elaborate more on how u did it?

if u refered any bolgs etc

Thanks,

Atul