Thanks for all your input.
I am able to read the data using the mentioned method. ie., creating the metadata manually with all the columns that are necessary. And reading the XML file. But now I have one more query.
Code: Select all
<HEAD>
<TRANS cd="2520" no="235" sls_amt="8657.75" trans_cnt="1224" sls_typ="MCP"/>
</HEAD>
<HEAD>
<TRANS cd="2520" no="235" dt_of_tx="20080213" />
</HEAD>
From the above data, the output should be,
CD. No, Sls_Amt, Trns_cnt, Sls_Typ,Dt_Of_Tx
ie., the First two fields CD and NO are the keys. so that rest of all the fields can be added as extra fields.
But how can I mark two fields as key?
If i mark so, Iam getting the following warning.
Code: Select all
Error: The link contains more than one repetition rule