| keith.duaime |
| Member |
|
| Wayne, PA |
|
|
| None Specified |
|
| Friday, April 22, 2011 |
| Tuesday, December 3, 2013 5:07:24 PM |
12
[0.07% of all post / 0.00 posts per day] |
|
|
Any info on SWIFT MT formats? We have interfaces the parse SWIFT MT 940s and 942s and looking for a better way to convert a camt.053.001.03 to MT940. With so may optional fields and layouts I was hoping for an EDI collection for SWIFT MT formats.
|
|
Basically how do I make a sequence number for the output resetting for a group but not counting the header records. I've been working on an example and think I've found the problem... I was using auto-number prior to the filter and additional conditions which was triggering the numbering.
|
I'm really surprised at this but I'm creating an output where details have to be sequenced, reset by group but only count on the details and not the group header and supplemental outputs.
i.e.
ACC,Account Number
BB,Date,Balance
BT,001,Date,Amount,Description
BT,002,Date,Amount,Description
ACC,Account Number
BB,Date,Balance
BT,001...
BT,002...
The output is just a simple text file and I actually concatenate the data since I can't use a switch because only the first switch is mappable and I tried filters etc but couldn't get that to work either so I just piece it together.
Simply put why can't there be 'evaluate when' be available similar to the Variable which I've also tried to no evail. Any ideas?
|
|
Since the output type was also complex I created a passthrough structure with all the data I needed concatenated and then passed the result to the output in a simple text output with duplicate input before and after for header/trailer and concatenated data in between.
|
|
Thanks, I realize that...
|
That's what I thought... I'm using a flex text config, repeated-split; del, crLf. a switch for line type, starts with 001,0002,etc...then storeas fixed file format.
If I concat one file format it works. When I try to connect more the line is blank. I also made sure to choose 'treat empty fields as absent' equally no.
|
vlad wrote:Use string-join function
What if you need it from multiple nodes?
<File>
<ctrlId>Control</ctrlId>
</File>
<Batch>
<batchId>Batch</batchId>
</Batch>
to be
<output>ControlBatch</output>
|
I'm trying to update a file with additional entries based on the existence in yet another file...
source.xml contains 4 fields which is a key that is too big to handle in our output.dat file so I'm using a cntlSeq.dat file. Basically I want to read the xml, find the key in cntlSeq.dat and update the sequence number to put it in output.dat. If the key doesn't exist I want to add it starting with 1 in output.dat but also want to update the cntlSeq.dat so if the same key is used it will be incremented. I can include a base example if need be but figured I might just be missing something that could be explained.
ctrlSeq.dat is an input Component with the name as the input. Followed by equals, logical and, if true val+1 else 1 and a filter on false to a duplicate row on output where the output filename is also ctrlSeq.dat and MapForce gives an error stating the file is in use. If I change the output file it works fine but if I run the same file again I get the value 1 since it's not appeneded to the file which is basically what I'm trying to do.
I did try to use a circular reference but also got an error for the same reason as I expected.
|
|
Once you filter all matching records create another filter where the node count equals 1. There may be something inline you can try but I had a similar problem and used the node count and filter after getting all matching records.
|
|
I've used FlexText to define a SWIFT MT message and is working but lately have been getting more requests to handle the SWIFT MT message formats. Are there any definitions or other users defining SWIFT MT messages with FlexText or some other method of handling them?
|
|
