Regarding Message Mapping

[former_member331856]

Hi ,

Please help me in creating the following Trget Structure.

Source Structure:

1|OPENED|153-01-19|T001|005151|0237|20080129|17:35:55|001 |20080129

101|A005152|1|20080129|11:46:38|001 ||||001||1|N|SALE

111|WCAKE004|1.000|42.00|42.00||G||0.00|LIQUOR|||N|42.00|0.00|$|0.00|WCAKE004

111|WCAKE004|-1.000|42.00|42.00||G||0.00|LIQUOR|||N|-42.00|0.00|$|0.00|WCAKE004

111|WCAKE005|1.000|38.00|38.00||G||0.00|LIQUOR|||N|38.00|0.00|$|0.00|WCAKE005

141|G|0.00

....

.....

101|A005162|1|20080129|16:44:17|001 ||||001||1|N|SALE

111|FANT003|1.000|12.80|12.80||G||0.00|TOBACCO|||N|12.80|0.00|$|0.00|FANT003

111|FANT003|-1.000|12.80|12.80||G||0.00|TOBACCO|||N|-12.80|0.00|$|0.00|FANT003

111|FANT001|1.000|12.80|12.80||G||0.00|TOBACCO|||N|12.80|0.00|$|0.00|FANT001

141|G|0.00

1|CLOSED|153-01-19|T001|005162|0237|20080129|17:35:55|001 |20080129

Required Target Strucure:

<?xml version="1.0" encoding="utf-8"?>

<ns:GMRStoreSales xmlns:ns="http://gmrstore.com/xi/GMRSTORE">

<CMD_CODE_1>

<KEY_FIELD1>1</KEY_FIELD1>

<SALE_DATE>20100705</SALE_DATE>

</CMD_CODE_1>

<CMD_CODE_101>

<KEY_FIELD1>101</KEY_FIELD1>

<TRAN_STATUS>SALE</TRAN_STATUS>

</CMD_CODE_101>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>WCAKE004</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>WCAKE004</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>WCAKE005</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_141>

<KEY_FIELD1>101</KEY_FIELD1>

<RECEIPT_NO>A005153</RECEIPT_NO>

</CMD_CODE_141>

<CMD_CODE_101>

<KEY_FIELD1>101</KEY_FIELD1>

<TRAN_STATUS>SALE</TRAN_STATUS>

</CMD_CODE_101>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>MM01</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>FANT012</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>FANT012</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_111>

<KEY_FIELD1>111</KEY_FIELD1>

<DISCOUNT_BY>0.00</DISCOUNT_BY>

<ITEM_STAX>0.00</ITEM_STAX>

<PLU_CODE>FANT012</PLU_CODE>

</CMD_CODE_111>

<CMD_CODE_1>

<KEY_FIELD1>1</KEY_FIELD1>

<SALE_DATE>20100705</SALE_DATE>

</CMD_CODE_1>

</ns:GMRStoreSales>

Please help me.

Reagrds,

Giridhar.C

Edited by: Giridhar Reddy on Jul 7, 2010 6:19 AM

Edited by: Giridhar Reddy on Jul 7, 2010 6:20 AM

[Former Member · Accepted solution]

Hi,

Are your key field values contsant? If yes why dont you try checking a constant value against the key field value adn then do the mapping for other target fields.

Regards,

Pragati

[former_member331856 · Accepted solution]

yes i tried with key field. but all the nodes under 111 are coming under same node. i need 3 items in the first transaction then 141 should follow. after that 111 one times hould come then 141 shuold follow. My Output format is like that.

Thanks,

Giridhar.C

[Former Member · Accepted solution]

Hi,

If my understanding is correct in ur current example you have data of 2 transactions:

101|A005152|1|20080129|11:46:38|001 ||||001||1|N|SALE

111|WCAKE004|1.000|42.00|42.00||G||0.00|LIQUOR|||N|42.00|0.00|$|0.00|WCAKE004

111|WCAKE004|-1.000|42.00|42.00||G||0.00|LIQUOR|||N|-42.00|0.00|$|0.00|WCAKE004

111|WCAKE005|1.000|38.00|38.00||G||0.00|LIQUOR|||N|38.00|0.00|$|0.00|WCAKE005

141|G|0.00

101|A005162|1|20080129|16:44:17|001 ||||001||1|N|SALE

111|FANT003|1.000|12.80|12.80||G||0.00|TOBACCO|||N|12.80|0.00|$|0.00|FANT003

111|FANT003|-1.000|12.80|12.80||G||0.00|TOBACCO|||N|-12.80|0.00|$|0.00|FANT003

111|FANT001|1.000|12.80|12.80||G||0.00|TOBACCO|||N|12.80|0.00|$|0.00|FANT001

141|G|0.00

so why don't you take the data of 1 transaction under 1 parent node in target, this will help out in separation. Your target structure could be something like this:

<?xml version="1.0" encoding="utf-8"?>

<ns:GMRStoreSales xmlns:ns="http://gmrstore.com/xi/GMRSTORE">

<P1>

<CMD_CODE_111></CMD_CODE_111>

<CMD_CODE_111></CMD_CODE_111>

<CMD_CODE_111></CMD_CODE_111>

<CMD_CODE_141></CMD_CODE_141>

</P1>

<P2>

<CMD_CODE_111></CMD_CODE_111>

<CMD_CODE_141></CMD_CODE_141>

</P2>

</ns:GMRStoreSales>

Regards,

Pragati

[Former Member]

Discarded

Edited by: Ramkumar Ganesh on Jul 7, 2010 6:35 AM