Output tool help

[RE5260]

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.

[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 · Accepted solution]

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

[ShankerV]

@RE5260 

Sure, please try and let me know if you have more questions.

Many thanks

Shanker V