Hi,

I am new to PDI world but had more than a decade of experience in Data Stage, Informatica, ODI and other ETL tools. I am trying to combine the data from two input data sets, apply some conditions on the columns and then insert or update the data into the target table:

Input Source 1:
EmployeeID
Middle Name_1
Suffix_1

Input Source 2:
EmployeeID
Middle Name_2
Suffix_2

Now, I have to check if the Middle Name_1 is NULL then Middle Name_2 will be sent to the target table but I am not sure how I can achieve this in PDI. Any help is greatly appreciated!
Thanks
NIvas