I have a problem statement as below :

From a DB source I have a table which has data related to Person. Out of which 3 columns are as Title, FirstName, LastName and I want to replace this as Name before actually putting it to the destination.

I tried using derived column but it gives me Name (ie. concatenation of Title, FirstName, LastName) and individual these columns as well.

Please suggest.