Keyfield - Content Conversion

keyfield is nothing but a field in a record of a file which will distinguish between the various records in the file.

for example;

01,aa,bb

02,cc,dd

02,dd,gg

03,tt,uu

here 01 is the key field for the 1st record, 02 for the next two records and 03 for the last record.

you can utilize the same in FCC.

ref:

Sender -

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter - TAB delimited

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

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

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

it is used in file adapter..

let's say, ur recordset structure is NameA with occurence 1 and NameB with occurence unbounded. So source file would look like:

++header

88someitem

88otheritem

88otheritem

..

++newheader..

The keyFieldValue is used to determine, when is has new structure started. Cos if u have unbounedd occurence, file adapter can't know, whether the item is header yet or item already.

So u use: nameA keyValue ++

nameB keyValue 88

and adapter goes through and thinks:

well, key field is ++ this is header, now 88 so it's item. now 88, it's item... ++ooops, i have to start new structure, cos' its header 😊

if ur recordset structure doesn't contain unbounded occurence of any item, you don't have to use keyField, cos it's clear that let's say -

nameA,1,nameB,3

in this case is each 4th line new header. one header, 3 items..

Clear?

Peter

Message was edited by:

Peter Jarunek