excel preview does not show 100 rows

Question

Hello,

I am reading a large excel file.   The preview only shows 1 row but when I add a browse tool I get all the rows.  I also notice that if I remove some of the columns I do see more rows (not 100) in the preview.

Is there a reason why I don't see all the rows in the preview on the input tool?

Thanks,

Michael

Jonathan-Sherman · Accepted Answer

Hi @mstoler,

Just to add a further point on @DavidP's reply. The results pane by default (when clicking on an anchor) will only display 1MB worth of data, enabling Alteryx to stay as fast as possible. You can see all the data using the browse tool which will remove that 1MB limit.

Regards,

Jonathan