Input Tool Reading only Header line and first line of the Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rnavane5,
Perhaps this thread helps: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/importing-1600-rows-via-text-file-but-...
Either:
1. Delete that input tool and drop the data inside the canvas again + ensure no limits placed on input
2. Update your Alteryx Designer and see if the issue persists.
3. Try running Alteryx as an Administrator as a bonus whilst you try No. 2.
Hope this helps.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
![](/skins/images/72080B1993C0EC7A53569ADF25905C2F/responsive_peak/images/icon_anonymous_message.png)