on 01-06-2010 12:14 PM
Hi All,
I have to sort an input file using XSLT mapping.
I have the input XML file.
The key to sort is the combination of three fields in the input.i.e PLANT,BATCHST,STK_RC.
e.g
<Detail>
<RECTYP>B</RECTYP>
<MATNR>14C3E8</MATNR>
<PLANT>3025</PLANT>
<BATCH>00000365</BATCH>
<STG_LOC>PIUS</STG_LOC>
<BOND_FLG></BOND_FLG>
<BATCHST>A</BATCHST>
<STK_RC></STK_RC>
<QP_STOCK>00000004.000</QP_STOCK>
<UOM></UOM>
</Detail>
<Detail>
<RECTYP>B</RECTYP>
<MATNR>700583</MATNR>
<PLANT>3025</PLANT>
<BATCH>0000148498</BATCH>
<STG_LOC>PLCL</STG_LOC>
<BOND_FLG></BOND_FLG>
<BATCHST>A</BATCHST>
<STK_RC></STK_RC>
<QP_STOCK>00000010.000</QP_STOCK>
<UOM></UOM>
</Detail>
<Detail>
<RECTYP>B</RECTYP>
<MATNR>138432</MATNR>
<PLANT>3025</PLANT>
<BATCH>0000148509</BATCH>
<STG_LOC>PLCL</STG_LOC>
<BOND_FLG></BOND_FLG>
<BATCHST>A</BATCHST>
<STK_RC></STK_RC>
<QP_STOCK>00000004.000</QP_STOCK>
<UOM></UOM>
</Detail>
Kindly suggest the step by step XSLT for the same.
Thanks!
Regards,
Indu Khurana.
Thanks,Its solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
May be you can start with the example(s) given here: http://www.w3schools.com/xsl/xsl_examples.asp
You can even write some sample code and check what/ how the output will be:
http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog_sort
Regards,
Abhishek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You should have good understaidng about XSLT programming,If you dont know anything then refer W3Scholls.com.
To write XSLT code use ALTOVA XML Spy or Stylus studio.using Altova mapper we can map the source taget structures.it automaticaly genarates code.
the same code you can use in PI.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.