inserting Excel Data into KNIME with Row Skipping

Hi,

We are currently attempting to insert data from an Excel file into KNIME using our existing workflow. The structure of the Excel file requires that we start reading the data from the 5th row, as the first four rows contain unnecessary information. Currently we have used python script to filter 5th row.

Could someone please recommend the appropriate node to use for this process? I’ve attached both the Excel file and the workflow for your reference. Any guidance on how to effectively skip those initial rows would be helpful. Thank you!


Hi @San_07,

You can make changes in your Excel Reader node itself.
In its configuration select Data Area tab and specify stating row as 4

Regards,
Yogesh

4 Likes

Hi @yogesh_nawale ,

Thats Working perfectly. Thanks @yogesh_nawale

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.