on 03-27-2007 9:01 AM
Hi,
My File Sender MT looks like this:
Root: 1..1
Header: 1..1
Row: 1..1
Body: 1..Unbound
Row: 1..1
Trailer: 1..1
Row: 1..1
Using this File Sender i want to read a flat file which has Header (1 row), Body (unknown rows) and Trailer (1 row), each kin of row has different field lengths.
The problem is that i don't have any Key Field to fit the file to the Recordset Structure: Header,1,Body,*,Trailer,1
What can i do??
yigal then by you cant do it by stand file adapter. as you dont have keyfeild values file adapter cant diffrenate between header,row,body.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abel,
If you are not having key fields and unable to read through adapter,
1) Read the entire file into one string through adapter
2) Must use java mapping program to split the the string into expected format according lengths.
Thanks,
venu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yigal,
Your requirement is not very clear. You have a different Message structure and a different Recordset structure. Which is the correct one? Or am I missing some thing here.. If possible give us a sample input file to get a better idea.
Regards,
Jai Shankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yigal,
This does not make much sense to me.
In your input file if all values are different, then how can <b>you</b> differentiate between a header, body and a trailer? There should be some value which uniquely identifies this. Check it again. That is the reason I asked for a sample input.
Hope you understand what I mean.
Regards,
Jai Shankar
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.