Solution to just knime it Challenge 2

[tommy]

hey KNIMErs

here is my solution:

Just KNIME it Challenge 2022 02 – tommy

regards
tommy

[dijkstran]

Hi heres my solution as a Component

JustKnime_Challenge_2_csvSplit – dijkstran

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]

My solution :

CHALLENGE 2 – david_foucout

[alinebessa]

Whoah! So many solutions already!

Here goes mine straight from the KNIME Hub.

[Thyme]

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.

JKI_002 – thyme

[AnilKS]

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]

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

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

[gonhaddock]

@Thyme

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

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]

Here my solution:

Challenge2 – santiagopc

Regards !

[SantiagoPC]

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]

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]

Here my solution:

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

[lucian.cristian]

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

knime_it_20220201 – lucian.cristian

[kowisoft]

@rs1

#justknimeit-2

Here’s mine. Finally a workflow I could solve

Once again great learning experience

Just KNIME it - Challenge 2 – kowisoft

[bruno29a]

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

Here’s my solution:

Just KNIME It Challenge 2 – bruno29a

[alinebessa]

Hello everybody,

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

Split File and Save Into Subfolders - Solution – alinebessa

If you like it, leave a little heart!

#justknimeit

[bruno29a]

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]

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

[alinebessa]

Good catch! It is now fixed.

Thanks!