Output tool help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Preparation
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'll try and let you know
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
