If there is too much data to display, then a sample will be displayed. That being said. All available data should be going through each tool. You can look at the record count in the result pane to verify that all data is being passed through and around properly:
For logic verification, you can create representative test samples that capture all possible cases within you data (which should be small enough to view all of) with the Text Input Tool. Then all you need to do is follow the workflow and make sure everything is working well before pulling in main data from data source.
That's not a cap, that's all the records/rows that made it to the Browse Tool (Or output anchor, depending on what you're viewing). Where are you pulling data from and how? Check your data source. If you have a Browse Tool connected directly to an Input Tool, then those 2000 records are all the records that the Input Tool is getting from the data source (barring some crazy bug, which is unlikely)
The Text Input Tool is pretty self-explanatory. It's basically as close to an excel spreadsheet as you can get. Just add Column names and then values underneath in the configuration menu for the Tool. When the workflow runs, it outputs exactly what you put in.
Hi @Alteryxuserhere,
I'm guessing you are talking about the display in the result window from the output anchor of your input tool:
I'd suggest:
This interactive lesson would be useful to your question:
https://community.alteryx.com/t5/Interactive-Lessons/Viewing-Data/ta-p/73953
Also look at the examples of the Browse Tool
In term of what you are seeing:
The output anchor of your input tool will only show a certain amount of data for a large data set:
source: Results Window (alteryx.com)
By default, the Results window displays the number of records shown in the window out of the total number of records in the data. For most tools, the Results window displays up to 1 MB of data, or up to 1,000 bytes of string data, for each tool anchor. If data exceeds 1 MB, the Results window displays a message that states that partial results are displayed.
To view all data from a tool in the Results window, add a Browse tool, and rerun the workflow.
To view more than 1 MB of data in the Results window without a Browse tool, adjust Memory Limit per Anchor in User Settings
The browse tool is supposed to always shows your complete dataset, regardless of the number of rows (i.e. 10 rows or 4 million rows).
When you click on an input output anchor on a tool it will usually give you an indication of the number records that was read in/out.
You can also check your log:
Also, in most cases when using join it is definitely worth checking the left (L) (in) anchor for the number of records read, and the join (J) (out) anchor should equal this number, if it does not then there should be an output in the Left(L) (out) anchor, the sum of these should equal what you read into the Left input, if not then there are likely duplicates in the right tables .
HTH
Tam
