cancel
Showing results for 
Search instead for 
Did you mean: 

Key field

Former Member
0 Kudos

In case of FCC what is the meaning of Key field ?? How to choose the key field ??the first field in a record structure is called key field ??

thanks

kumar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you want to convert a file as shown below in to an XML structure

01 header headerdetails

02 item1 item1details

02 item2 item2details

<MessageType>

<Recordset>

<Header>

<Id>01</Id>

<Type>Header</Type>

<Details>headerdetails</Details>

</Header>

<Items>

<Id>02</Id>

<Type>item1</Type>

<Details>item1details</Details>

</Items>

<Items>

<Id>02</Id>

<Type>item2</Type>

<Details>item2details</Details>

</Items>

</Recordset>

</MessageType>

To distinguish which record of the file belongs to which substructure you need a keyfield. There should be one common field in all the substructures. In the above examples it is "id".

CC Parameters:

KeyFieldName: id

Header.keyFieldValue: 01

Items.keyFieldValue:02

Regards,

Sudheer.

Message was edited by:

Sudheer

Former Member
0 Kudos

Hi sudheer ,

Thanks for your reply! you are telling 'Id' is a key field. why can't it be "Type" ??

and also why can't it be "Details" field ?? They are also common fields in all substructures right ??

thanks

kumar

Former Member
0 Kudos

Hi,

I am sorry for the wrong example. In this example it can be anything but in real time the fields in header and items will be completely different except one or two. In that case there should be one common field to be used as KeyField. Now if you see the above example i have changes the values in the file. Here you cannot use keyfield as item or item description because the values are not same in all the items. hope i am clear now.

Regards,

Sudheer.

Message was edited by:

Sudheer

Answers (0)