Hi All,
Could you please assist in importing more than 1000 records using input data tool.
I have set the record limit to 10000 so that input data should not be missed but getting only 1048 records from 1431 - Please find the attachment.
Thank you
Solved! Go to Solution.
I’m not sure I understand the issue - why are you saying it’s not pulling all the records? You may want to put a browse tool down after your input - each anchor only stores 1 MB of data for display purposes, so the browse tool is necessary for larger data sets
@bubblyjai1982
I can get 1430 rows, which should be correct.
Can you share your workflow so we can take a look?
As I answered in my response, put down a Browse tool, run it, and use it to see all data
Alteryx will not by default show you all records from the input or subsequent tools (for performance reasons), so your flow is pulling all the records, as you circled in red, it pulls 1430, but shows only more than a thousand.
In order to see all records in your results, either:
Again, this is for performance reasons, so Alteryx doesn't bog down, if you start importing hundreds of thousands of records. This is by design.
Forgot to mention that using many browse tools in your flow is not advisable (performance reasons - because they pull all data and depending on your machine, you could easily run out of memory resources!) and browse should be used only for building or troubleshooting a flow.
Thank you All !!