CODEWITHSUNDEEP
pentahokettlepentaho-spoon
Jason Mell
Jason Mell

Reputation: 103

Pentaho: Kettle/Spoon: Combining multiple data after inserts

I'm using Pentaho's Kettle/Spoon to load a Customer. I can't figure out how to join 2 or more transformations together after they're complete

     Source
  /    |     \
 A     |      B
  \    |     /
   Insert Data

(Database Alpha)
Source Data 
ID, Name, SSN, Email, CanCall, EmailStatus

(Database Beta) 
A) Inserts the email status table if it doesn't exist then returns the ID
B) Inserts the PII table if it doesn't exist then returns the ID
Insert Data 
EmailStatusTable
1, can_email
2, can_not_email

PII Table
1, "Johnson, John", "todays_date"
2, "Jackson, Jillian", "todays_date"

CustomerTable
1, 1 (PII Table ID), "[email protected]", true (can call), 1 (email status table ID) 
2, 2 (PII Table ID), "[email protected]", false (can call), 2 (email status table ID)

I can't figure out how to make the "Insert Data" portion work. Help please.

Upvotes: 1

Views: 285

Answers (2)

Ankit Srivastava
Ankit Srivastava

Reputation: 256

Combination lookup/update

step will solve your problem very easily

enter image description here

Upvotes: 2

karan arora
karan arora

Reputation: 184

You can use flags by setting the variables inside the transformations and use those flags values to insert data in the customer table. As mentioned by you, you have to return ID, Here return ID means you have to set that variable as a result or flag inside the transformation. Requirement is very simple. IF you need further help, please reply on the same.

Upvotes: 0

Related Questions