TimeXtender has a feature called Custom Table Insert. This feature allows user to add data to a table based on a custom SQL query

To use this feature, right-click the table you want to add data to, select Advanced, and then select Add Custom Table Insert.

In the script editor, create a SQL SELECT statement - no INSERT clause is necessary.  The script should look like this: 

SELECT 
[FirstName], 
[MiddleName],
[LastName], 
[FullName] AS [Full Name]
FROM [Person]

If the field names in the source tables are different from the field names in the destination table table, use an alias to make the names match up.