Creating Log changes

HI

I have source file that contains the updated information and I wanted to append it against the old file, then creates a log(in string) on another column which includes the following info (header name that was changed, old file value)

Here's an example:

FILE 1 (updated info)
EMPID NAME DESIGNATION DEPARTMENT
101 Jessica Supervisor Accounting
102 Jose AsstManager Workforce
104 Lesar Staff IT

FILE 2 (master file - older)
EMPID NAME DESIGNATION DEPARTMENT LOGS
101 Jessica Staff Accounting N/A
102 Jose Admin Operations N/A
103 Anne Analyst Finance N/A
104 Lesar Staff Helpdesk N/A

Master File will be updated to
EMPID NAME DESIGNATION DEPARTMENT LLOGS
101 Jessica Supervisor Accounting **Updated DESIGNATION: Staff > Supervisor
102 Jose AsstManager Workforce[/color] **Updated DESIGNATION: Admin > AsstManager **Updated DEPARTMENT: Operations > Workforce
103 Anne Analyst Finance[/color] N/A
104 Lesar Staff IT **Updated DEPARTMENT: Helpdesk > IT

Thank you for this interesting question
Yes it is possible to achieve your objective.
I have created for you a working example using sub transformation so the logic an be reused .
If you decide to add more fields you would need to edit log message

Attached actual transformation together with sample files