Alteryx is not fetching all the records from Netsuite ODBC database

[tkhan016]

Hello,

I am using SQL query to import data using Netsuite ODBC into Alteryx. The count of record which I got after running the SQL query was 21345 and the data fetched into Alteryx using the same SQL query was 20982. I am not really sure why is there a gap in the count between the records fetched into Alteryx  and the actual count of records.

[danilang]

Hi @tkhan016 

Can you show us why you think that not all the rows were input?  If you looking at the results window in any tool other than a browse, you might see something like this.

Alteryx only displays the first X rows of data to limit memory use.  All the rows are there and will be processed, but only a subset will be displayed.  If you add a browse tool, you'll see all the rows.

Dan