Key Field Name?

[Former Member]

Hi Experts,

In file adapter wht is the main purpose of Key Field Name in File content conversion? wht shld be the value for this field?

Cheers

Faisal

[Former Member]

The key field name comes into picture when file structure is a bit complex. Take the example of a simple sales order. Assume that sales order is received in form of a text file. The first row has header information like customer details and order details; whereas the remaining rows have order items details. Every field has different lengths and there are no field separators.

To specify the name and occurrence of each sub-node in Structure we use key filed name. In this case, Order node occurs once while Order Item node can occur any number of times. Key Field Name and Key Field Type help in differentiating different substructures. In this case Key =1 implies Order node while Key = 2 implies Order Item node.

Hope this helps.

[Former Member]

> In file adapter wht is the main purpose of Key Field Name in File content conversion? wht shld be the value for this field?

Hi,

The main purpose of KeyField is to distinguish the Header, Body & Trail in the incoming text file.

Just go through this blog it will help you to understand the concept & how to use the key field.

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

Regards,

Sarvesh