Also i want to add 2 additional columns with 1 value across all rows - the values of the columns are specified below: value against FundID and FileFormat as per below screeshot:
Question: Do I need to create the knime table step first to be able to do any operation on the table (or can i do any of the operation above after CSV reader step)?
the first rows appear to be completely blank (am I right?). In this case, you could set the csv reader so that each file is read starting from a certain row on.
An alternative could be filtering out all row ids that have a pattern like “// #” at the beginning. I imagine row “// Variables” to be the header, so you to keep it.
HI @lelloba ,thanks , the first solution works great as I just tested it.
Regarding the 2nd point "//Variables’ is not a header it , it just contains some top level information about the file however as it is in a row 7 (which in this configuration from CSV reader includes column headers) , I wont be able to remove it.
Out of curiosity , which node to use for filtering?