Hi everyone!
I processed information in alteryx and now I need to export it in txt file, but I have more than 2,000,000 rows, for example CSV file only accept 1,048,576.
How can I solve this?
HI @Hannia_Ruíz,
I was thinking about this and there is a simpler "hack" that might work for your situation without a macro. Look at the attached workflow. It tags the data in groups of 1 million rows, then uses that tagging to create separate Excel sheets or CSV workbooks. It will work for any amount of data lines.
CSV Output tool setupExcel Output tool setupWorkflow
Hi @Hannia_Ruíz
1,048,576 is the Excel row limit. CSV format is not limited to that, are you getting an error or warning exporting the data from Alteryx? My guess is you're running into issues trying to review in excel.
Hi @Hannia_Ruíz,
The 1,048,576 row limit is an Excel limit, not a CSV limit. You can create a CSV with over 2 million rows, it just cannot be opened intact in Excel. You would still be able to open the file in a text editor such as Notepad. The question becomes what needs to be done with the 2 million rows of data after processing it through Alteryx. Is someone needing to review each line item? If yes, you may need a database to store the data, but that would be a lot of data to look at. If the data just needs to be browsed, then the text file could be brought into an Alteryx app with Interface tools attached to Filter Tool(s) to narrow the data to what the user needs to look at.
yes!, I can export it to DB, but sometimes I woutd like to divide the 2M into two sheets.
Thank you for you answer. @T_Willins and @Luke_C
Regards!
