Number of records

[Simraneyy]

I am working on consolidating huge files, if I choose excel, it exceeds the number of rows, if I choose CSV it does not load completely when I open,

Is there any other way to save

[sparksun]

Why not use .yxdb?

[Simraneyy]

Can you explain how it is done, will this extension open in excel?

[Tiffyyy]

you can try to download text editor like Notepad++ (https://notepad-plus-plus.org/downloads/) or sublime (https://www.sublimetext.com/download) to open large csv file.

Just curious, why you would want to open the file after exporting out from Alteryx Designer?

[danilang]

Hi @Simraneyy 

What's the purpose of your consolidation?  How is the consolidated data going to be viewed?  Excel has a hard 1M row limit per sheet, so you can't use excel to view all your data on a single sheet.  This applies to your csv file as well, if you use excel to open it.  Open the csv with notepad and you'll see that all the rows are there.  

The output that you choose will depend on the answers to the first 2 questions.  Maybe you don't need to see all the data on a single sheet.  In that case you can output the data to multiple sheets in excel based on some criteria.  Check out the answers on this post to see examples of that.     

Dan