XML Newbie:Can this Be Done

[Scott Boucher]

I have an XML document that looks like this:

- <MSG>
- <HDR_DATA>
<DATE>20040211</DATE>
<STORE_NUM>2210</STORE_NUM>
<REG_NUM>5</REG_NUM>
<TRANS_NUM>1234</TRANS_NUM>
</HDR_DATA>
- <DTAIL_DATA>
<CODE>222222</CODE>
<SIGN_FLG>0</SIGN_FLG>
<QTY>222222</QTY>
</DTAIL_DATA>
- <DTAIL_DATA>
<CODE>333333</CODE>
<SIGN_FLG>0</SIGN_FLG>
<QTY>333333</QTY>
</DTAIL_DATA>
- <DTAIL_DATA>
<CODE>444444</CODE>
<SIGN_FLG>1</SIGN_FLG>
<QTY>444444</QTY>
</DTAIL_DATA>
</MSG>

I want the XML Document to Look Like ThisEssentially, I want
HDR_DATA to appear with each DTAIL_DATA)

- <MSG>
<DTAIL_DATA>
<DATE>20040211</DATE>
<STORE_NUM>2210</STORE_NUM>
<REG_NUM>5</REG_NUM>
<TRANS_NUM>1234</TRANS_NUM>
<CODE>222222</CODE>
<SIGN_FLG>0</SIGN_FLG>
<QTY>222222</QTY>
</DTAIL_DATA>

<DTAIL_DATA>
<DATE>20040211</DATE>
<STORE_NUM>2210</STORE_NUM>
<REG_NUM>5</REG_NUM>
<TRANS_NUM>1234</TRANS_NUM>
<CODE>333333</CODE>
<SIGN_FLG>0</SIGN_FLG>
<QTY>333333</QTY>
</DTAIL_DATA>

<DTAIL_DATA>
<DATE>20040211</DATE>
<STORE_NUM>2210</STORE_NUM>
<REG_NUM>5</REG_NUM>
<TRANS_NUM>1234</TRANS_NUM>
<CODE>444444</CODE>
<SIGN_FLG>1</SIGN_FLG>
<QTY>444444</QTY>
</DTAIL_DATA>
</MSG>

 

[Unregistered]

It parses without error. I edited it to remove redundancy. How does thi
look?

<?xml version="1.0"?>
<MSG>
<DTAIL_DATA>
<DATE>20040211</DATE>
<STORE_NUM>2210</STORE_NUM>
<REG_NUM>5</REG_NUM>
<TRANS_NUM>1234</TRANS_NUM>
<ITEM1>
<CODE>222222</CODE>
<SIGN_FLAG>0</SIGN_FLAG>
<QTY>222222</QTY>
</ITEM1>
<ITEM2>
<CODE>333333</CODE>
<SIGN_FLG>0</SIGN_FLG>
<QTY>333333</QTY>
</ITEM2>
<ITEM3>
<CODE>444444</CODE>
<SIGN_FLG>1</SIGN_FLG>
<QTY>444444</QTY>
</ITEM3>
</DTAIL_DATA>
</MSG

Unregistered

 

[Patrick TJ McPhee]

[...]

% I want the XML Document to Look Like ThisEssentially, I want
% HDR_DATA to appear with each DTAIL_DATA)

Using xslt, use a template like this

<xsl:template match='MSG'>
<DTAIL_DATA>
<xsl:copy-of select='HDR_DATA/*|DTAIL_DATA/*'/>
</DTAIL_DATA>
</xsl:template

 

[Scott Boucher]

It Looks Great, but how did you do it. Parsed it with what. Also do
not want the data tag <ITEM#>

Thanks

 

[Tripredacus-X]

It Looks Great, but how did you do it. Parsed it with what. Als
do
not want the data tag <ITEM#>

Thanks

Well i just noticed the redundancy and determined a more compact way o
displaying the same data. The smaller the file the faster it processes
Remember that there are many ways of displaying the same data, whethe
it be more fleshed out like yours or more compact like mine.

I used the <ITEM#> tag as a placeholder for whatever tag name yo
wanted to use. I used it just as an example.

As for -how- I did it... I noticed that a lot of data values wer
repeated:

<DATE>20040211</DATE>
<STORE_NUM>2210</STORE_NUM>
<REG_NUM>5</REG_NUM>
<TRANS_NUM>1234</TRANS_NUM>

So I consolidated this into one entry and created child elements fo
the data that was different. If there were two different dates, stor
numbers, etc I would have had to reorganise it differently.

But I don't see where the "'HDR_DATA" comes into play..

Tripredacus-