Icon

03-Filenames and Metadata (Solution)

ZIDAS2020 | Data Analysis with KNIME | Exercise 3Goal: extract metadata from filenames; how do Exp1,Exp2 and Exp3 differ?Strategy:- prerequisite: convert RowID into text column- multiple alternatives: - split the filename at unique character occurrences - use regular expressions to extract matching groupsRequired nodes:- RowID Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8 CSV Reader RowID Cell Splitter Regex Split Column Rename Column Rename GroupBy GroupBy ZIDAS2020 | Data Analysis with KNIME | Exercise 3Goal: extract metadata from filenames; how do Exp1,Exp2 and Exp3 differ?Strategy:- prerequisite: convert RowID into text column- multiple alternatives: - split the filename at unique character occurrences - use regular expressions to extract matching groupsRequired nodes:- RowID Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8 CSV Reader RowID Cell Splitter Regex Split Column Rename Column Rename GroupBy GroupBy

Nodes

Extensions

Links