adding a column csv -> access

Dear all,

I am reading a csv with 3 fields:
field1
field2
field3

Now I need to insert a column named field_new between field1 and field2 to have the below sort order:
field1
field_new
field2
field3

I have to write an access table with this order.

I tried with constant value column node but was only able to append the new column to table’s end.

Does anyone has an idea how to realize?

Thanks for help!

BR,

Heinz

Hi @Heinz

Use a Column Resorter for this :wink:

image

5 Likes

Thank you very much; you made my day :slight_smile:

2 Likes

You can use the ‘Column Resorter’ node in KNIME
open its configuration, and arrange the columns as ‘field1’, ‘field_new’, ‘field2’, and ‘field3’.

give reference from attached image

Screenshot 2024-01-10 103410

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