Input more than 1000 records

[bubblyjai1982]

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 

[alexnajm]

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

[Qiu]

@bubblyjai1982 
I can get 1430 rows, which should be correct.
Can you share your workflow so we can take a look?

[bubblyjai1982]

Sorry Qiu

I was on leave couldn't respond back.

Please find the attached file for your reference. 

Many Thanks

[alexnajm]

As I answered in my response, put down a Browse tool, run it, and use it to see all data

[jirikrecek]

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:

• Add a browse tool and copy data into a clipboard to see all 1430
• Output the data into a file using the output tool

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.

[jirikrecek · Accepted solution]

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. 

• Once your flow is done, you can easily disable all browse tools in your flow in the Configuration pane's Runtime tab, there is a checkbox for that.
• Do not ever save a final flow with browse tools being all enabled. It wastes resources, slows the flow, and may cause memory errors.

[bubblyjai1982]

Thank you All !!