OUTPUT ERROR: NUMBER OF RECORDS EXCEEDS THE EXCEL MAXIMUM

[CathrinaJay]

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

[ShankerV · Accepted solution]

Hi @CathrinaJay 

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

Many thanks

Shanker V

[ShankerV]

Hi @CathrinaJay 

It is due to output tool.

Many thanks

Shanker V

[DenisZ]

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

[CathrinaJay]

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

[DenisZ]

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

[ShankerV]

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]

Hi @CathrinaJay 

Please find the default .CSV format.

Sample Output:

Please find the output:

Each columns are separated by delimiters.

Here as default ',' is the delimiter used.

Many thanks

Shanker V

[ShankerV]

Hi @CathrinaJay 

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

Output:

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

Many thanks

Shanker V

[CathrinaJay]

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