You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FileRead using Fileadapter does not ignore trailer row.

edited Feb 20, 2020 4:44PM in Integration 1 comment

Summary

FileRead using Fileadapter does not ignore trailer row.

Content

Hi,

I am trying to upload a file into DB using File Adapter.

File type is CSV below is a snippet of the data in the file.

OIC isn't able to ignore the trailer record ( I have attached error and file read setup  for reference )

Can anyone help  please? I am facing the same issue even when I stage the file and read from it.

Sample File ( csv )

"FILE_HEADER","FXR","GRP","FXRATES_NYK",2019-11-12,2019-11-13 02:35:15

"AED","AFN",2019-11-12,2019-11-18,"EOD Spot",21.39823587063051290428

"AED","AFN",2019-11-12,2019-11-18,"MTD Average",21.31555412887278167462

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!