Input Tool Reading only Header line and first line of the Data

Question

I have an Input file in .xlsx format which has only 175 lines. When I connect in Input tool, the input tool reads only the Header and the first line of data alone. Not sure whats the issue.

I tired multiple ways. Making this sheet as separate file.

I copied this input tool alone to a blank workflow where I could see all the data. Only when I use this in my actual workflow, this problem persists

Input tool in Workflow.PNG

Same input tool just copied and pasted in blank workflow and working fine.PNG

apathetichell · Answer

use browse - not the results tab. Sometimes if you have ram issues things can get stuck and you won't see your full datastream in results.

rnavane5 · Answer

This may look weird to you guys. But this is the fact :-)

I was trying to troubleshoot this issue. So attempted with various iterations like completing creating new input file with few rows, then full data and also recreate this alteryx workflow.

While doing this, I could found one weird issue. This input tool is further going to a Transpose, then select and then Join multiple. If I disconnect connection between Select and Join Multiple, the Input Tool node shows all 175 records. When  do this connection between Select to Join Multiple, only one record is shown in the node of Input Tool. Attaching screenshot of same.

Input when connected to Join Multiple tool.PNG

Input tool not connected with Join Multiple Tool.PNG

rnavane5 · Answer

1. I tried already and it was not working. I couldnt conclude if the problem is with the .xlsx file or with the input tool. When I copy this input tool as it is in another blank workflow, it gives me complete data. Similarly if I use this file with new input tool in blank workflow, it gives me complete data

2.I updated the Alteryx version. Still the problem persists

3. I use my organisation account. Not sure how to run as Administrator.