Data Input - Only first record is being read

Question

I have a data input tool that is reading from a .csv file in my workflow. Out of a few hundred rows of data, only the headers and first row of data is being brought into the workflow with the data input tool. I double checked the properties of the data input tool, and the settings are what they should be. Does anyone know what might be causing this issue?

rnavane5 · Answer

Hi,

Did you get any solution for this. i also face same problem in .xlsx file. it reads only one line and header. But when I simply copy this input tool to a blank workflow and run it, it reads all data..

MassPat · Answer

Were you ever able to get this resolved? I'm running into a similar issue, and can't quite figure out what's going on. Especially since it works with other Excel files of similar structure.

CoreyJ · Answer

Hey Jonathan,

Unfortunately, I'm unable to upload the workflow or even post an image of it, due to the client data it is built for. There are 109 columns within the .csv file, and I do currently have a browse tool connected to the data input tool. I am actually unable to see any of the data when using the browse tool, I need to click on the green output arrow of the data input tool to see the one record that is being read.

Apologies for being unable to share images, I understand that makes troubleshooting more difficult.