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 :(

[mceleavey]

Hi @novalcia ,

you would need to provide your workflow and sample data so we can see what's going on.

Feel free to just copy the input, we don't need the whole workflow if that would be a problem.

M.

[novalcia]

The sample data is attached. And there isn't really a workflow yet, it's just this:

The sum from alteryx: -9,249,168,853,148.31

The sum from excel: -9,249,173,477,576.03

[Tam · Accepted solution]

@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 

[novalcia]

Thank you so much! I just updated from version 2020.4 to version 2022.3 and this was no longer an issue. Thank you!