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.
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