| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How can we do it in a mapping node... |
« View previous topic :: View next topic » |
| Author |
Message
|
| mirakal |
 Posted: Sat Dec 01, 2007 2:11 pm Post subject: How can we do it in a mapping node... |
 |
|
Novice
Joined: 19 Sep 2007
Posts: 11
|
Hi,
I am looking for some hints on how to deal with the following tasks in mapping node.Here is what I am in need of help.
My source:
<CustomerOrder>
<CustomerDeatils/>
<TimeUpdated/>
<Item Number/>
<CustomerOrder/>
My target:
<OrderType>
<Transaction Time/>
<VendorList/>
<Business Unit Number/>
<OrderType/>
I mapped the incoming TimeUpdated to Transaction Time, but I need the output from the map to be 12/01/2007 instead of December 01 2007.Do I have to call esql function for this or can I do in the mapping node itself if there is any date format conversion available.
Secondly, I mapped the Item Number to Business Unit Number where the incoming value is '100107' but I need the out put from the map to be ' 100107'.(need to add 5 spaces before the value) so that it can be processed at the target end application.How to add the required spaces before the source value in the target side in mapping node.
It would be great if you can help me on this.
Thanks,
Mirakal. |
|
| Back to top |
|
 |
| francoisvdm |
| Posted: Sun Dec 02, 2007 10:15 pm Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
I do not know about your first requitement, but to add spaces is easy, just use fn:concat() in the map.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
