Solution to just knime it Challenge 2

morpheus · February 4, 2022, 7:18am

Hi all,

here is my solution.

i would be happy about any comments and suggestions. Just for impoving my knowledge

BR

tommy · February 4, 2022, 7:44am

hey KNIMErs

here is my solution:

regards
tommy

dijkstran · February 4, 2022, 9:06am

Hi heres my solution as a Component

I experienced, thanks to this challenge, that the “Create missing folders” option of the csv writer does not work in combination with a Connector node. It seems that the export has to be done in two steps. 1 make folder, 2 make csv. Is this right?

David_Foucout · February 4, 2022, 4:13pm

My solution :

alinebessa · February 4, 2022, 10:32pm

Whoah! So many solutions already!

Here goes mine straight from the KNIME Hub.

Thyme · February 5, 2022, 2:02pm

So I tried to Node Golf this:

Java Snippet to create the filename (also fix the date format)
Group Loop over the filenames
unfortunately, the Group Loop Start changes the data type of the filename to String, so I have to use String to Path (Variable) to fix this
Column Filter to get rid of the filename
CSV Writer to write the results, while automatically creating missing folders

Does anybody know how to add a tag on the Hub? I can’t figure it out.

AnilKS · February 5, 2022, 2:54pm

short and crisp approach … how can we configure if want to store the data in local file system … There is no option which place my folder be … i am unaware where my file would be … workflow is run without error. i want to store the data in seperate file with subfolder named as year and month and sub file name accordingly.

gonhaddock · February 5, 2022, 11:53pm

Here is my solution for Challenge 2:
#justknimeit-2

KNIME Hub > gonhaddock > Spaces > Just_KNIME_It > Just KNIME It _ Challenge 002

gonhaddock · February 6, 2022, 12:33am

Hi @Thyme
In the Description panel of the Work Flow:
View > Description
You will be able to personalize the ‘Description’, ‘Tags’ and ‘Links’

Regards

SantiagoPC · February 6, 2022, 2:06am

Here my solution:

Regards !

SantiagoPC · February 6, 2022, 2:16am

Set the fields data with a Cell Splitter

https://forum.knime.com/t/solution-to-just-knime-it-challenge-2/39335/31?u=santiagopc

Thyme · February 6, 2022, 9:07am

Thank you @gonhaddock, I figured it out in the meanthyme. Didn’t occur to me to look in the WF itself.

Btw, your Column Filter doesn’t do anything.

cf_123 · February 7, 2022, 8:52am

Here my solution:

knime://My-KNIME-Hub/Users/cf_123/Public/CL2

lucian.cristian · February 7, 2022, 10:04am

i use this a lot and was really happy to see i could actually approach a #knimeit challenge

kowisoft · February 7, 2022, 11:42am

Here’s mine. Finally a workflow I could solve

Once again great learning experience

bruno29a · February 7, 2022, 2:07pm

Hello everyone, since this is still very much very active, I’ve decided to give it a go too.

Here’s my solution:

alinebessa · February 8, 2022, 3:08pm

Hello everybody,

Here’s our solution to the challenge, created by its author Emilio Silvestri.

If you like it, leave a little heart!

#justknimeit

bruno29a · February 8, 2022, 3:38pm

Hi @alinebessa , I’m not sure that the workflow is doing what the requirements ask.

“As an example, the data for January 2015 should be stored in a file named 2015/January.csv”. If I’m not mistaken, the Table Writer would create Knime table files, not csv.

Also, the data being saved, which is coming directly from the Group Loop Start would include the original columns + the columns generated by the String to Date&Time and the Extract Date&Time Fields nodes. From what I understand, the requirement was to just split the original data into different sub-files without any modification of the data or additional column.

elisrich · February 8, 2022, 3:55pm

This is my solution to challenge 2
I tried to keep it as simple as possible

alinebessa · February 8, 2022, 4:14pm

Good catch! It is now fixed.

Thanks!