on 10-02-2007 3:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.