Table Error : Error String size limit reached: Strings are limited to 214748

[hemant86]

Hi Team,

I have 1.2 GB of data as input and trying to extract some data out of it. I'm getting the below errors. Any idea what could be the reason. Appreciate any help.

"Find Replace (123) The source input is optimized for datasets of ~100,000 or less. Performance may be improved by using a join instead."

" Table (107) Error String size limit reached: Strings are limited to 2147483648 bytes"

[kathleenmonks]

Hi @hemant86,

For the first error, have you tried using a join instead? Is there a particular reason you're using a Find Replace tool? Based on the information in the screenshot, it looks like a join would work great here.

For the second error, my hunch is that it is the same issue in this thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/String-limitation-error/td-p/469822  The final comment mentions that a single table/layout/string field has a limit of 2.14 GB of data and that is inclusive of the format styling. So considering you have 1.2 GB of data and what looks like a lot of formatted columns, you might be hitting that limit. The solution mentioned in that comment is to split the data into multiple tables and then use styling to make it appear as one.