CODEWITHSUNDEEP
pentahokettle
qapt
qapt

Reputation: 101

Kettle - Two csv inputs into PostgreSQL output

I have a class project using Pentaho. I need to create a dashboard using 2 different inputs into a PostgreSQL output. My problem is, using Kettle, I have to match two different .csv files that go into the Postgres. One of the csv is about crimes, the other is about weather. I manually added two columns into the weather one, so they have two matching columns: 'Month' and 'Year'.

kettle transformation

My question is how can I use this matching columns (or does doing that make any sense) so I can later create the dashboard and make queries like 'What crimes where committed when it was raining?'.

Sorry if I'm not very accurate, I'm a bit lost at using Pentaho. If anyone could give me some help I would be thankful.

Upvotes: 2

Views: 92

Answers (1)

Egor Zhuk
Egor Zhuk

Reputation: 276

If your intent is to join two CSV files, please check the Join step.

Upvotes: 2

Related Questions