Maximum string limit reached in table tool

[SCK]

Hi All.. I need help in creating an output. My total records is 49726246 which I can see through browse tool. I tried using table reporting tool, however, I ended up getting an error that string size limit reached. 

Is there any other option I can output the data? Please help

[Emil_Kos · Accepted solution]

Hi @SCK,

According to this topic there is a workaround for this problem:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Table-tool-error/td-p/469772

in the last post @CharlieS attachted a workflow that could help you in your case.

[SCK]

Thanks so much, I tried it but guess my data is way too large so I will have to use a lot of filters to get the desired output.

[SCK]

 @CharlieS Hi Charlie. I followed @Emil_Kos suggestion to refer your solution on size limit error in table tool

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Table-tool-error/td-p/469772

However,I am still getting an error - 'out of memory' - as shown below:

Would you please be able to help on this.

[Emil_Kos · Accepted solution]

Hi @SCK,

Now it actually looks like you don't have enough ram. 

Maybe you can check topic below: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Memory-allocation-problem/td-p/93396

Hope this help you will your problem 🙂 

[SCK]

Thank you so much, it worked! 🙂