Appending data source columns

This feature benefits you if you’re an Orbit connect user, and wish to append extra columns to an existing data source. If you have already uploaded a file and wish to add columns, then you can do so via this process.

Note: New columns may only be added if they are located to the right of the existing data source columns in the new upload file.

Note: The steps below detail appending columns to a file upload, but the process applies to both file uploads and and Amazon S3 based data sources.

To append additional columns to a file upload:

1. Open Apteco Connect, using the connect icon in the top right hand side of your screen.

   

2. Go to DATA SOURCES.

   

3. On an existing data source, open the ellipsis option menu and click Edit.

   

4. Click Select file, and select your updated file.

   

   Once complete, a ‘New Columns Added’ information flag is displayed, stating which new columns have been added.

   

5. Click Update. Connect now removes all previous existing data and appends the new columns.

   

6. Now, go to TABLE DEFINITIONS.

   

7. On the corresponding Table Definition, open the ellipsis option menu and click Edit.

   

   An information message is displayed stating that you have new variables available to add.

   

8. Click + Add Variable, select the relevant added columns, and click Add.

   

9. Add a Data Definition for the added columns.

   

10. Click Save Table.

    

    You’ve now appended the columns of an existing data source.