|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Comparing 2 xml's and get the matching field's values
Hello,
I am having 2 xml's say...dsg.xml and my.xml as dsg.xml --------- <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE dsg SYSTEM "dsg.dtd"> <DBCSSCHEMA> <TABLE name="t_fbpe_part_earn" shortname="fbpe"> <FIELDLIST> <FIELD name="clnt_id_n" type="int" /> <FIELD name="ssn_n" type="char" default1="' '" /> <FIELD name="earn_rcvd_ts" type="datetime" default1="' '"/> <FIELD name="earn_type_c" type="char" default1="' '"/> <FIELD name="pay_prd_end_d" type="datetime" default1="' '"/> <FIELD name="earn_q" type="float" default1="' '"/> <FIELD name="data_src_type_c" type="char" default1="' '"/> <FIELD name="rec_upd_type_c" type="char" default1="' '"/> <FIELD name="rec_upd_ts" type="datetime" default1="getdate()" /> <FIELD name="rec_upd_user_nm" type="char" default1="XYZ" /> </FIELDLIST> </TABLE> <TABLE name="t_fpaa_activity" shortname="fpaa"> <FIELDLIST> <FIELD name="clnt_id_n" type="int" /> <FIELD name="ssn_n" type="char" default1="' '" /> <FIELD name="earn_rcvd_ts" type="datetime" default1="' '"/> <FIELD name="earn_type_c" type="char" default1="' '"/> <FIELD name="benf_c" type="char" default1="' '"/> <FIELD name="pay_prd_end_d" type="datetime" default1="' '"/> <FIELD name="rec_upd_ts" type="datetime" default1="getdate()" /> </FIELDLIST> </TABLE> and my.xml as ------- <?xml version="1.0" ?> <!DOCTYPE workbook SYSTEM "workbook.dtd"> <workbook> <sheet> <name value="tbcc"/> <row number="0"> <col number="0" field="Create new calculation using Calc Creator tool"></col> <col number="1" field="See modCalcCreator in Calc Creator for instructions on data for fields."></col> </row> <row number="1"> <col number="0" field="t_tbcc_benf_calc_creator"></col> <col number="1" field="clnt_id_n"></col> <col number="2" field="db_plan_n"></col> <col number="3" field="ssn_n"></col> <col number="4" field="benf_c"></col> <col number="5" field="plan_feat_c"></col> <col number="6" field="bcd_d"></col> <col number="7" field="benf_pmt_a"></col> <col number="8" field="benf_calc_c"></col> <col number="9" field="srvr_ben_pmt_a"></col> <col number="10" field="pmt_stop_d"></col> <col number="11" field="pmt_stop_rsn_c"></col> <col number="12" field="svc_qty_q"></col> <col number="13" field="ben_elig_d"></col> <col number="14" field="nxt_pmt_adj_a"></col> <col number="15" field="nxt_pmt_adj_d"></col> <col number="16" field="srvr_pmt_adj_a"></col> <col number="17" field="acru_benf_a"></col> </row> <row number="2"> <col number="0" field="(Link to Calc Creator)"></col> <col number="1" field="15180"></col> <col number="2" field="001"></col> <col number="3" field="236-64-6709"></col> <col number="4" field="1001"></col> <col number="5" field="1"></col> <col number="6" field="8/7/91"></col> <col number="7" field="1032.59"></col> <col number="8" field="2"></col> <col number="10" field="21/9/99"></col> </row> <row number="3"> <col number="0" field="xyz"></col> <col number="1" field="15180"></col> <col number="2" field="001"></col> <col number="3" field="236-64-6666"></col> <col number="4" field="1001"></col> <col number="5" field="1"></col> <col number="6" field="8/7/91"></col> <col number="7" field="1032.59"></col> <col number="8" field="2"></col> <col number="10" field="21/9/99"></col> </row> </sheet> <sheet> <name value="Sheet2"/> </sheet> <sheet> <name value="Sheet3"/> </sheet> </workbook> Now what I want is...compare these 2 xml's...In this, if for table 't_fpaa_activity'...clnt_id_n & ssn_n are matching with my.xml. Now what I want in my result is, the values of these 2 fields...ie., 15180, 236-64-6709 15180, 236-64-6666 (ie., 2 separate records) Can anyone please help me in this regard. I used 2 classes, which reads these 2 xml's separately. But matching is where I am facing problem. Thanks in advance |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > XML Programming > Comparing 2 xml's and get the matching field's values |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|