Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

OUTPUT ERROR: NUMBER OF RECORDS EXCEEDS THE EXCEL MAXIMUM

CathrinaJay
7 - Meteor

Hi please help. What do I do about this error? Thanks!

 

CathrinaJay_0-1669102657744.png

 

15 REPLIES 15
ShankerV
17 - Castor

Hi @CathrinaJay 

 

Kindly change the file output to some other formats such ".csv" or ".yxdb" where possible

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @CathrinaJay 

 

It is due to output tool.

 

ShankerV_1-1669103181833.png

 

Many thanks

Shanker V

 

 

DenisZ
11 - Bolide

Please opt for other data sources than .xlsx when dealing with larger datasets. .csv would solve most issues relating to large dataset. 

CathrinaJay
7 - Meteor

hello, if I select .csv as the output format what should I put in the configuration panel below?

 

CathrinaJay_0-1669103459679.png

 

DenisZ
11 - Bolide

@CathrinaJay This depends on the data, the standard should work. Try running it and see if the output is as expected. 

ShankerV
17 - Castor

Hi @CathrinaJay 

 

The default for .csv pick up.

I would recommend to proceed with as is in default for .csv format.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @CathrinaJay 

 

Please find the default .CSV format.

 

ShankerV_0-1669103965961.png

 

Sample Output:

 

Please find the output:

ShankerV_1-1669104026492.png

 

Each columns are separated by delimiters.

Here as default ',' is the delimiter used.

 

 

Many thanks

Shanker V

 

 

 

ShankerV
17 - Castor

Hi @CathrinaJay 

 

If you have , used in your dataset use the delimiter which is unique.

 

ShankerV_0-1669104223098.png

 

Output:

ShankerV_1-1669104319922.png

 

Kindly let me know if I could help on anything else if struck.

 

Many thanks

Shanker V

 

 

 

CathrinaJay
7 - Meteor

The workflow worked perfectly without error but I cannot open the file it says FILE NOT LOADED COMPLETELY.

Labels