Split data into different sheets in the same workbook

Hi everyone! In my excel workbook I have a column with around 100.000 keywords. Now I want to have these keywords in different sheets with 10.000 rows each, but in one common workbook. How can I do that? Thanks for any of your ideas!
Cheers, Alex

Here is a basic approach to splitting the dataset, you should just need to swap the table writer out for the Excel writer and control the sheet name via flow variable.

3 Likes

Hi @AlexHex

Welcome to the forum! :slight_smile:

That requires a loop and some more configuration of the Excel writer. I attached you an example
SplitDataToDifferentSheets.knwf (160.8 KB)
hope that helps and can serve as a starting point.

Best,
Alice

2 Likes

Hi Alice! Thank you for the perfect solution, it works fine! :smiley:

1 Like

Hi iCFO, thanks for the solution! :smiley:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.