Input Fixed Length file only one record selected

[rockeylearning]

Hello!

I have an input that reading the fixed length data .txt file, I got the .flat file built with all the required fields. However, when workflow run, it only find one record from the file. What am I missing?

Thank you in advance for your help!

[binuacs · Accepted solution]

@rockeylearning Your file never has a new line character. If you open the file in a notepadd++ you will be able to see all the records in one line. I updated the workflow to split the file based on the field length

[rockeylearning]

Thank you so much @binuacs ! I've added the new line character and now I can see all the records. That fixed the issue.

Thank you again for your help!