Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
FileRead using Fileadapter does not ignore trailer row. — Cloud Customer Connect
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.

Received Response
15
Views
1
Comments
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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