Input Tool Record reading Limitation (Excel)

Question

Hi,

I see partial records have been displayed and i used Browse tool to view complete data set.

However, only partial data have been considered while its used in Replace and find tool.

So, please advise on this.

Is there an option to extend the data range which can be used completely when we use it further in Replace and find tool.

Thanks,

Vishnu33 · Answer

Thank you

danilang · Answer

Hi @Vishnu33

Here's the extract about the results window from the Alteryx Help page

The message that you're seeing is only referring to the display in the results window.

In order to optimize memory, the results window only a subset of the data for all tools except the Browse tool.  In the example above, I have 100000 rows in the dataset, but only ~43,000 are shown.  In a Browse tool, I can see all the rows.

All the rows are there.

In your case, The Find Replace tool is working with all the rows in your dataset, but the result window only shows some of the data.   If you add a browse tool after the Find Replace, you'll see all the results.

@acarter881:  The message that you shared has to do with the performance of tool and not the amount of data that it can work with.  The Find Replace is significantly slower than the Join tool.  Both will process all the data but the Join will process it faster.  Of course, if you're doing partial matches, the Find Replace may be your only option since the Join works with whole fields only.

DAn

acarter881 · Answer

Hello, @Vishnu33. I believe this is a limitation of the Find Replace tool. You may be getting this Warning in the Results window. I suggest using a Join tool instead.