Row Delimiter after column 1, should be seen at end of row?

dataservices job design
1

Hi

Getting this weird problem with a file I load every month. It is a small simple file with 4 columns. Nothing that I am aware has changed, the job is the same the file is the same structure.

Each column has a pipe separator and row delimiter is new line.

No idea why it is now saying the pipe is a row delimiter?

Hope someone can help as my hairs are growing greyer with this thing!

grifter (BOB member since 2013-01-09)

2

This may be because of some of the cells may have different data format in the second column, ensure there are no blank spaces before or after the data in the rows as well as ensure that there is no blank lines appended at the end of the last row in the files, if any delete them, this may resolve your issue.

BOBJFan (BOB member since 2011-09-24)