Icon

Extract table from txt file - KNIME Forum (91178)

<p>Extract table from txt file - KNIME Forum (91178)</p>

Dynamically identify the start of the second table

Summary of Data.txt
CSV Reader
Top Table
Row Filter
Bottom Table
Row Filter
Row to Column Names
Row to Column Names
Constant Value Row Appender
Row Filter
Date as RowID
RowID
Date as RowID
RowID
Row Filter
Concatenate
Table Row to Variable
String to Date&Time
by RowID
Column Appender
result.table
Table Writer
Column Filter
RowID
identify line holdingColumn1=WOPR
Row Filter
if($["Date"]=="P102","",$["Date"])
Expression
Table Row to Variable
if($["Date"]==MISSING,"P102",$["Date"])
Expression
$[ROW_NUMBER]
Expression
$RowNr$11
Math Formula

Nodes

Extensions

Links