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

how to skip a column in while reading the file of fixed length in OIC (FTP Adapter)

Accepted answer
74
Views
12
Comments

Summary:

Hi,

We are reading a fixed length file from an FTP directory using FTP adapter. There is one column in the file which have different length of characters. For example, we defined in the XSD schema this column will be 30 chars but in the file for some records we will receive 30 chars and for some records it may be not 30 or less than 30. So in this case integration is going into error that file translation is not as per the the schema content.

Is there any way we can skip that column while reading the file ? I mean data should be in the file but while reading the file we will skip that columns data, is it achievable ? or please suggest a workaround. Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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