Icon

JKISeason2-30_​sryu

There has been no title set for this workflow's metadata.

Challenge 30: Music Data App
Level: Medium or Hard

Description: The second season of Just KNIME It! is coming to an end, and just like last season we will celebrate it with an open-ended problem. We invite you to use your creativity to build a data app relating music tracks to their artists through interactive and insightful visualizations. Take a step further and use one of the datasets we provide to make your interface available in multiple languages. Note: As this is an open-ended challenge, we will not be supplying our own solution as we usually do. Feel free to explore the datasets as you see fit!

artist.csvsongs.csvtracks.csvlanguage_texts.xlsxno of tracks / year&artistrelease yearSplit artist name with delimiter "__".yearDelete unnecessary symbolsyearIn the case of multiple artists, the intervening symbols are grouped and converted to a dummy delimiter "__".Converted to data for each artistJoin with artist listExtract artist namesno of trackstop20only artistartists to yearNew ROW IDunpivotfor color settingcreate rankingAppend colors to the cellsvisualizationCreate random color codes without PythonCreate only light-colored color codesCSV Reader CSV Reader CSV Reader Excel Reader GroupBy String Manipulation Cell Splitter Sorter String Replacer Group Loop Start String Manipulation Ungroup Joiner GroupBy Loop End (ColumnAppend) Sorter Row Filter Column Filter Column Rename(Regex) RowID Unpivot String Manipulation String Manipulation Component Metanode Python Script artist.csvsongs.csvtracks.csvlanguage_texts.xlsxno of tracks / year&artistrelease yearSplit artist name with delimiter "__".yearDelete unnecessary symbolsyearIn the case of multiple artists, the intervening symbols are grouped and converted to a dummy delimiter "__".Converted to data for each artistJoin with artist listExtract artist namesno of trackstop20only artistartists to yearNew ROW IDunpivotfor color settingcreate rankingAppend colors to the cellsvisualizationCreate random color codes without PythonCreate only light-colored color codesCSV Reader CSV Reader CSV Reader Excel Reader GroupBy String Manipulation Cell Splitter Sorter String Replacer Group Loop Start String Manipulation Ungroup Joiner GroupBy Loop End (ColumnAppend) Sorter Row Filter Column Filter Column Rename(Regex) RowID Unpivot String Manipulation String Manipulation Component Metanode Python Script

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: sryus
Created at: 2023-10-18
On NodePit since: 2023-10-23
Last update: 2024-11-21
Created with KNIME version: v5.1.1
Tags: JKISeason2-30

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!