Spit output data into multiple excel files based on number of rows of output data
- 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
I want to have data into either 1 excel file or split into multiple excel files based on no.of rows of data. If the output data is 75000 then I should get 1 file but if it is 1 lakh then there should be 2 files
1 - File 1 containing 75000
2 - File 2 containing 25000
If there are 2 lakh records
1 - File 1 containing 75000
2 - File 2 containing 75000
3 - File 3 containing 50000
I already added RecordID tool to create block based on number of records.
I'm getting "You must specify a sheet name Error". It would be great if someone could help share the workflow and steps to build it. Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank for the Links but none of the links have a accepted solution. Is there anything else that I can refer? Please let me know. Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for putting together solution