Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Last record of the excel is not pulling to the Alteryx Canvas

ShravaniCh
5 - Atom
‎09-27-2022 01:26 AM

Hello,

 

I ham having an excel file that has 1048576 records in a sheet, when I am trying to input data through Input tool the last record is not reading by Alteryx. Anyone aware this issue? 

 

Thanks in advance!

Labels:
Reply
0 Likes
3 REPLIES 3
flying008
15 - Aurora
‎09-27-2022 01:33 AM

Hi, @ShravaniCh 

 

What are you used version of Alteryx ?

 

flying008_0-1664267622033.png

 

Reply
0 Likes
ShravaniCh
5 - Atom
‎09-27-2022 01:51 AM

Using Version: 2020.4.5.12471

Reply
0 Likes
flying008
15 - Aurora
‎09-27-2022 02:08 AM

Hi, @ShravaniCh 

 

Error: Output Data (5): Number of records exceeds the Excel maximum (1048575). Remaining records will be truncated.

So maybe you can try :

1- input the .xlsx file with version above 2021.3.*  or

2- change the input File Format option to "Microsoft Excel Legacy(*.xlsx)" , then you can input the data row of 1048576.

 

**********

Please mark this as a solution and give a like if it solves your problem.

Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All