New similarity search2.xlsx (54.5 KB)
For eg this is the sheet and if I want to seperate data into differnt excel tabs based on Genere or anything else as well how do I do that :-
unable to understand how to achieve spit into differnt exel tabs can someone please help → found this workflow but how does chunk loop start and variable loop end work
Hi @praveenrajp
Instead of the Chunk Loop Start, use the Group Loop start.
In my example column1 defines the new sheet names. Configure the Excel Writer.
And in the flow variable tab use column1 for the new sheet names.
gr. Hans
group split.knwf (159.7 KB)
Please find my workflow - PLease can you rectify it I want to create differnt tabs based on genre - Additionally we dont need variable loop ends (whats the use of it)
please complete the workflow i can us it as a base to understand how it works as I’m new to knime
Praveenraj
Is Action, Adventure, Sci-Fi just one genre. Or are these 3 different genres, with 3 different tabs?
There are 183 unique tabs , If you can group for any 3 genre all the data into 3 specific tab :-
Eg all Comedy, Drama, Romance data in one tab - with columns-> Series_Title; Released_Year & Genre - I will try to group other Genres- Please share your workflow .
Genre available Eg :-
Comedy, Drama, Romance
Crime, Drama
Biography, Drama, History
See this wf [group split_v2.knwf|attachment]
gr. Hans
it seems the the image and the workflow attached are both different [group
please share the workflow shown in the image as i wanted to see the configuration for teh workflow in the image
Thanks,
Praveen
Hi @praveenrajp
My fault, here is the wf that matches the image group split_v2.knwf (331.4 KB)
gr. Hans
Unable to execute please use your own data and share - Error workbook already contains sheet named action and adventure in second node excel writer and in first node excel writer -Error workbook already contains sheet named action
Hi @praveenrajp
To many things went wrong with your question, sorrry (murphy’s law). Here is the final and hope correct one that helps you to move on with your project. Both Excel Writer nodes need a Variable Loop End. And the error messages in the Excel Writer shows up if you run the workflow a second time (there is already a workbook with the name)
split_genre_in_a_loop.knwf (256.5 KB)
gr. Hans
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
