OUTPUT ERROR: NUMBER OF RECORDS EXCEEDS THE EXCEL MAXIMUM

[CathrinaJay]

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

[ShankerV]

Hi @CathrinaJay 

Righclick on the output file, Select Openwith and Select Notepad

This will help to open the file. If you are trying to open again in Excel, that might lead to error which you are encountering.

Many thanks

Shanker V

[CathrinaJay]

Is it possible to save in excel format with the exceeding rows be saved in the next sheet?

[ShankerV]

Hi @CathrinaJay 

There are many possible solution for your latest question.

Mentioning few below, pick which one works for you based on the data set you have.

Many thanks

Shanker V

[ShankerV]

Hi @CathrinaJay 

Option 1: Use the Record ID tool.

This will create unique record for every row.

Then Split your data's based on the record id where record ID < 1000000

Where filter will have T and F node

T will contain record ID < 1000000

F will contain record ID > 1000000

Output into excel sheet from both T and F node separately

Many thanks

Shanker V

[ShankerV]

@CathrinaJay 

Option 2: Use the Record ID tool.

This will create unique record for every row.

Use a formula to create groups of 1 million per group (Use tile tool)

Output to your excel file just adjust the tool to create new tabs based on this grouping. 

Hope the solution helps!!!!!!

Many thanks

Shanker V

[CathrinaJay]

hi can you show me how to configure the formula tool? Here's mine