How to merge 7 CSV files in KNIME I am very confused, especially for CSV files whose id contents are different from the others, can anyone provide a tutorial?

KNIME Analytics Platform
1

This is the csv i use :

how can i merge this csv ?

2

Could you provide some detail about what you’re trying to do?

2 Likes
3

Hi,

have you checked the Website you’ve posted?
At the bottom you can find several examples on how the data set is used and how to merge the tables.
E.g.:
Python - Looker Ecommerce Data Analysis

If you want to do the same I highly recommend the L1 course provided here:
KNIME Learning Center | KNIME

There you should find some information how to JOIN or CONCATENATE different tables.

Andreas

3 Likes
4

Merge it with what exactly?

On the purely technical side, you load two .csv files with “CSV Reader” nodes and to pass them into a “Joiner” node.

Either the ID is a unique and valid identifier for your data points across all tables - then you wouldn’t do that.

Or the ID only identifies entries /within/ a given table - then you’d join on another column that makes sense to your use case.

1 Like
5

You can also look at the KNIME YouTube channel:

1 Like