How to joing multiple csv files as input in knime

KNIME Analytics Platform
#1

I have 3 CSV files with different columns say : 

csv1 : id,pid,sol

csv2:id, feature1,feature2,feature3,feature4

csv3:pid, f1,f2,f3,f4,f5,f6

i want to use them for a classification problem wher sol column in csv1 is the actual predictedvalue. 

I want a final like : 

id,pid, feature1,feature2,feature3,feature4, f1,f2,f3,f4,f5,f6,sol 

How can i do it in knime without explicitly making a single csv file ? 

#2

csv1(id) -> csv2(id) 

csv2(pid) -> csv2(pid)

 

after join the csv eliminated same attibutes  {:^)

#3

Hi,

you would use three csv readers. Than join csv1 and csv2 on attribute ID. And the result of this you join to csv3 on attribute pid.

Best, Iris