Input tool shows last rows as null, even though they are null and shouldn't be mentioned

Question

Hi there,

I recently used the input tool to upload an excel file on Alteryx Designer. The file had data till row number 991. Surprisingly, the Input tool showed 64K rows, and the rows after 991th row where actually null.

Now, I want to know two thing:

1. Why would alteryx show ~63k null rows at the end of my sheet when I know that those are null and shouldn't be mentioned by input tool?

2. Even though I know it won't be the case but could there be anything wrong with my excel file for alteryx to show rows till 64k and not 991?

Thanks in advance!

delete this.PNG

binu_acs · Answer

@tushar_Kumar_bain as @JarekSkudrzyk mentioned there might be spaces or null values after the row 991. You can check your excel file and remove the extra lines after the 991 record and try again or use the Data cleansing tool to remove the null rows and null columns

JarekSkudrzyk · Answer

@tushar_Kumar_bain hi, I think there must have been some kind of data in row 63k, but without the file and data I can't tell for certain.
You can bypass this problem by adding filter tool that will get rid of any rows with nulls in column F2.