Follow

How to create a custom table insert

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.

 

pic1.png

 

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.

Was this article helpful?
3 out of 3 found this helpful

2 Comments

  • 5
    Avatar
    Stuart Cuthbertson

    It would be great if this could be added to the main PDF User Guide :) 

  • 0
    Avatar
    Michael Rygaard

    I think I got this, but this is not a How to, this is a "yellow Post It" note to someone who already knows what to do.

    1. Where should the source be
    2. how should it be formatted
    3. will this be done before any field transformations, or should i include those in the source
    4. make a screen shoot the source, and then the script and then the result.

     

     

     

     

    Edited by Michael Rygaard
Please sign in to leave a comment.