Icon

m_​001_​import_​spectral_​data

list scans, extract headers, combine data

list a more complex txt file. extract aheader and transpose it. Extract the data and combine them

list scans, extract headers, combine datalist a more complex txt file. extract aheader and transpose it. Extract the data and combine themhttps://forum.knime.com/t/extrakt-two-variables-from-txt-files-in-a-folder-and-combine-with-a-third-variable-time-given-in-the-file-name/21907/5 ../data/import/import txtfilenew_row_idFirst rowdetermine line which reads>>>>>Begin*keep the datanew_row_id_beginkeep the headsplit by :file_namesplit by \tmax 2convert tonumbercollectresultbring toone lineHead_*Head_typeas RowIDJoin dataand meta dataresult_together.tableresult_lines.tableresult_head.table List Files File Reader Table Row ToVariable Loop Start URL to File Path String to URI Extract URI Info Java Snippet(simple) Row Filter Rule-basedRow Filter Rule-basedRow Filter Table Rowto Variable Column Rename Rule-basedRow Filter Cell Splitter ConstantValue Column Cell Splitter Column Rename String ToNumber (PMML) Column Rename Loop End (2 ports) Transpose Column Filter RowID Joiner Table Writer Table Writer Table Writer list scans, extract headers, combine datalist a more complex txt file. extract aheader and transpose it. Extract the data and combine themhttps://forum.knime.com/t/extrakt-two-variables-from-txt-files-in-a-folder-and-combine-with-a-third-variable-time-given-in-the-file-name/21907/5 ../data/import/import txtfilenew_row_idFirst rowdetermine line which reads>>>>>Begin*keep the datanew_row_id_beginkeep the headsplit by :file_namesplit by \tmax 2convert tonumbercollectresultbring toone lineHead_*Head_typeas RowIDJoin dataand meta dataresult_together.tableresult_lines.tableresult_head.tableList Files File Reader Table Row ToVariable Loop Start URL to File Path String to URI Extract URI Info Java Snippet(simple) Row Filter Rule-basedRow Filter Rule-basedRow Filter Table Rowto Variable Column Rename Rule-basedRow Filter Cell Splitter ConstantValue Column Cell Splitter Column Rename String ToNumber (PMML) Column Rename Loop End (2 ports) Transpose Column Filter RowID Joiner Table Writer Table Writer Table Writer

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: m_lauber
Created at: 2020-03-24
On NodePit since: 2020-04-09
Last update: 2024-04-25
Created with KNIME version: v4.1.2

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

Try NodePit Runner!