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!
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!
1 Like
Hi iCFO, thanks for the solution!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.