Browse tool and Connection Progress

Hi All

I'm new to Alteryx and I'm wondering how do I get the browse tool to display all data from the input tool? The reason for this is I'm not sure how much data is it extracting and therefore when I use Join and Union tools, I can't verify if the results are valid or not.

I tried setting the Connection Progress to be always show in Canvas settings, but it doesn't always show.

Any solutions to this?

Thanks all

Input

Accepted answers

Tam

In that case it is a cap. Salesforce tools when you are trying to pull from a report will only permit 2000 rows. Limitation i believe is on Salesforce side not Alteryx.

regards

Tam

All comments

CoG

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.

Alteryxuserhere

Thanks for your prompt reply.

Mine gets capped at 2000. How do I remove this limit? Can you also elaborate how I can use the Text Input tool?

Screenshot 2024-01-05 130423.png

CoG

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.

Screenshot 2.png

Alteryxuserhere

Thank you @Tam @CoG

I'm using Salesforce Input and when I click on the input output anchor it will show me 2,000 rows but I know that from the Salesforce data I have more than 2000, which is why i thought it caps at 2000.

Screenshot 1.png

Tam

In that case it is a cap. Salesforce tools when you are trying to pull from a report will only permit 2000 rows. Limitation i believe is on Salesforce side not Alteryx.

regards

Tam

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280