Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

rnavane5
5 - Atom

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 

4 REPLIES 4
caltang
17 - Castor
17 - Castor

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.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
rnavane5
5 - Atom

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.

rnavane5
5 - Atom

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.

apathetichell
19 - Altair

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.

Labels
Top Solution Authors