Output tool help

Hello All,

I have an output tool which produce excel output with an existing formatting. The workflow run creating excel output but the format changed. The Output tool gives some error with regards to range of data.

Only have to work in the path or the output tool to get the original excel output. Unfortunately I'm unable to provide the source file/ workflow.

Error: Encountered existing data beyond the specified range.

Output tool configuration window -

Kindly help.

Tips and Tricks

Preparation

Accepted answers

ShankerV

Hi @RE5260

To save in excel format with the exceeding rows be saved in the next sheet.

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

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

All comments

grazitti_sapna

@RE5260 , This is because the data overflows the range you have provided in your output tool. Kindly increase the range values and then try again.

ShankerV

Hi @RE5260

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

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 @RE5260

To save in excel format with the exceeding rows be saved in the next sheet.

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

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

RE5260

I'll try and let you know

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703