1 of my rows is missing when I open my data in Alteryx

novalcia

I have a data file which contains a column named Amount. The sum of my Amount is different when I use Excel and when I use Alteryx. Turns out the last row is missing when I open it in Alteryx. Here's the last few rows of my data:

The left column is the data when opened in Excel, and the right column is the data when opened in Alteryx. What happened? How could Alteryx lost the last row like that?

I literally only opened the data:

What do I do? How do I get the last row of data? This is messing up my calculations

Tam

@novalcia Can you post the Result -Workflow - messages please. Also what version of Alteryx Designer are you using.

From what you've describe, it's looks like only 1048574 records were read in and you were expecting 1048575 records. 

I was able to replicate you issue in Alteryx Designer 2020.2.3.27789 however in 2022.3.1.532 Patch:5 the issue could not be replicated. 

In designer Alteryx Designer 2020.2.3.27789 if you tried to write 1,048,575 (+1 row for variable name) to an excel file you will get a message of Error: Output Data (3): Number of records exceeds the Excel maximum (1048575). Remaining records will be truncated.

alternative solution is to ask for or convert the file to CSV prior to reading it into Alteryx. 

HTH 

regards 

Tam