Join Multiple CSVs with different column headers

Hi everyone,

How do I join multiple files (or in this case CSVs) into 1 file? I’m new to Knime so I apologize if this is a common knowledge. I’ve been reading posted topics but I can’t find a direct answer to my problem. My problem is — I have at least 12 CSVs that I want to join. I want to join them by their unique IDs and combine the columns in the output file. Here’s a sample of the data:

File 1

| Column 1 | Column 2 | Column 3 | Column 4 |
| id       | housing  |          |          |
| 3100205  | 46       |          |          |
| 3100240  | 200      |          |          |
| 3100415  | 944      |          |          |
| 3100555  | 835      |          |          |
| 3100625  | 248      |          |          |

File 2

| Column 1 | Column 2   | Column 3 | Column 4 |
| id       | population |          |          |
| 3100205  | 96         |          |          |
| 3100240  | 403        |          |          |
| 3100415  | 1504       |          |          |
| 3100555  | 1370       |          |          |
| 3100625  | 472        |          |          |

File 3

| Column 1 | Column 2 | Column 3 | Column 4 | E        | F        | G        |
| id       | income_1 | income_2 | income_3 | income_4 | income_5 | income_6 |
| 3100205  | 34       | 5        | 2        | 0        | 0        | 0        |
| 3100240  | 121      | 2        | 2        | 0        | 0        | 0        |
| 3100415  | 522      | 41       | 14       | 10       | 7        | 2        |
| 3100555  | 468      | 25       | 8        | 4        | 2        | 2        |
| 3100625  | 171      | 13       | 6        | 4        | 0        | 2        |

The output file should be like this:

| Column 1 | Column 2 | Column 3   | Column 4 | E        | F        | G        | H        | I        |
| id       | housing  | population | income_1 | income_2 | income_3 | income_4 | income_5 | income_6 |
| 3100205  | 46       | 96         | 34       | 5        | 2        | 0        | 0        | 0        |
| 3100240  | 200      | 403        | 121      | 2        | 2        | 0        | 0        | 0        |
| 3100415  | 944      | 1504       | 522      | 41       | 14       | 10       | 7        | 2        |
| 3100555  | 835      | 1370       | 468      | 25       | 8        | 4        | 2        | 2        |
| 3100625  | 248      | 472        | 171      | 13       | 6        | 4        | 0        | 2        |

Thanks everyone for your help!