append rows in csv by criteria

[anguslou]

I want to append rows in a CSV file based on content and criteria in a table, eg.

Original CSV:
Name. Class.
John. 3B
Mary 4C
Mary. 3B

Table
Name. Class. Number
Mary. 4C. 2325

So that new CSV is:
Name. Class. Number
John. 3B
Mary 4C. 2325
Mary. 3B

How to add a new column in the CSV file base on criteria from a table?

[tommy]

hi @anguslou ,

I’d configure the following setup:

• csv reader and writer point to the selected file (Local File Browser Config)
• join: left outer join based on Name and Class
• csv writer: mode “overwrite”

I’m sure you won’t be able to append columns to existing rows without reading the file and overwriting it.

Hope that helps, regards, Tommy

[rd2575691]

Hello,

Does this help?
new_column_addition.knwf (24.5 KB)

[anguslou]

Yes, it works, Thank you.