Xlsx Output

[SouravKayal]

Hi ,

I am trying to output to an Xlsx output which was working fine till a week back. I am using Designer V 2020.2.3. It has around 550K rows and I am getting an error of aborting due to exceed size limit.i am able to get a csv dump though. Even after i try to convert the csv it keeps giving me the same error. I checked with browse tool as well and only see 577K records. 

Can someone help if faced similar issues

[rkapoor]

@SouravKayal maybe this article on the Community will help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-Not-Reading-Large-File/td-p/11...

[SouravKayal]

@rkapoor  heres the thing, when i limit the records as well, or when i read it full i am able to read the full 577K records but when it outputs , its throwing me an error of large sheet size

[rkapoor]

@SouravKayal what error do you get. Check this article out which may help:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Managing-Exceeding-file-size-limit-err...

[SouravKayal]

aborting process, exceeds file limit. But i am writting only 577755 rows

[rkapoor]

@SouravKayal I think the link I posted may help you