on 2019 Oct 29 9:41 AM
Hi Experts,
We trying to pick up files from SFTP server but we always have the error encountered as titled here. Our source file is like below:
"BEG","1.0","D","test.tst","10022019"
"testing","1234","test only","asdf","fdsa","10","20","30","5","10","30","4321","987","ref1","ref2","ref3","ref4","ref5","test.tst"
"EOF","1","95"
Can anyone advice on this?
We have below configured for the FCC.
Error encountered:
Hi Joel!
I may be wrong, but:
"If you have entered a variable number of substructures under Recordset Structure, that is, you have entered the value * for at least one structure, specify a Key Field Name.
The parser identifies the substructures by their content. This happens using the key field with different constants for the substructures. In this case, you must specify a key field, and the field name must occur in all substructures."
I guess that you should include the key field in each of your described structures and assign key field value for those structures.
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your response. I tried using MessageTransformBean cause been reading that SFTP FCC is bugged. But then keyFieldName is required regardless for multiple structure. I just went to take all the rows as single Recordset and just manipulate in mapping to format on the intended structure.
User | Count |
---|---|
68 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.