| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Merging Flat File in Message Broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| Paul Deepak Raj |
 Posted: Mon Mar 23, 2009 8:02 am Post subject: Merging Flat File in Message Broker |
 |
|
Newbie
Joined: 23 Mar 2009
Posts: 2
|
All,
We have a requirement to merge two flat files based on key fields and if matched, sum up other fields(integer/decimal data types) as below.
Flat File1
Col1(String), Col2(Integer), Col3(Integer), Col4(String), Col5(Decimal)
James, 43600, 01, Sales, 85789.567
Peter, 34500, 09, Finance, 45678.907
Dylon, 23450, 05, Marketing, 6543.965
Merging key fields: Col1, Col3 and Col4
Flat File2
Col1(String), Col2(Integer), Col3(Integer), Col4(String), Col5(Decimal)
James, 23100, 01, Sales, 47457.650
Peter, 34500, 09, Marketing, 7865.765
Dylon, 12700, 05, Marketing, 2345.908
Expected Output:(Col2 and Col5 are summed up, if the key fields are matched)
James, 66700, 01, Sales, 131468.474
Dylon, 23450, 05, Marketing, 8889.873
Peter, 34500, 09, Finance, 45678.907
Peter, 34500, 09, Marketing, 7865.765
Please provide me your suggestion on how we could implement this requirement in Message Broker. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Mar 23, 2009 8:08 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
It's very straightforward to implement this in Message Broker.
The training you have taken should have told you what nodes to use and how to wire them together correctly.
Surely you're not asking for free training from us, correct?
 |
|
| Back to top |
|
|
| Paul Deepak Raj |
| Posted: Mon Mar 23, 2009 8:14 am Post subject: |
|
|
Newbie
Joined: 23 Mar 2009
Posts: 2
|
mqjeff,
I accept that i am very new to this tool and did not have any training outside.
This may be an easy solution. But, since i am aware of what/how to proceed further, could you please help me out in this regard? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Mar 23, 2009 8:23 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
This forum is not a training resource.
Please go read the product documentation.
Please use the Samples that come with the product. |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Mar 23, 2009 8:35 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Paul Deepak Raj wrote: |
| I accept that i am very new to this tool and did not have any training outside. |
Mention this to whoever gave you the task, and ask if they'd want you to fix the brakes on their car without training.
WMB is not a straightforward tool, and what you've asked can't be answered in a simple post.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
