Data Append

Coupler.io allows you to fetch data from several sources at the same time, and combine it in the destination into a unified dataset - all with a single importer.

Coupler.io has three data-combining modes: 

• Append
• Join
• Aggregation

Feature description

Video instruction

When combining several sources in Append, Coupler.io compiles the list of unique column names from all the sources it’s meant to stitch. It then puts all data under these columns, using their names as identifiers and keeping rows' content as it was in the sources. Here are two examples:

Example #1 (both sources have the same columns):

Example #2 (some columns are the same for both sources, and some are unique per each source):

What business cases can data stitching in Append mode solve?

Here are a few use cases that you may find useful ( note: column names should be the same):

• Stitch the same data entity from several accounts (e.g., Invoices from two different Xero tenants).
• Stitch Google Sheets, Excel, or CSV files from different  GDrive / OneDrive storage.
• Stitch several pages from a JSON source that has small pagination limits.
• Stitch different data entities from the same source (e.g., Invoices, Bills, Payments from QuickBooks Online) to build a custom report.

Which sources can be combined with Append?

Coupler.io does not limit the sources that you can stitch - you can combine all sources that are available in your plan.

Just notice that the Append data combining mode works properly when data sets have the same columns returned. Otherwise, you will get just two data sets in the destination file without any interconnections between them.

How to Append data?

There are a few simple steps on how to add several sources to your importer and stitch them together in Append. For this:

1. After adding the needed sources, go to the "Transformations" step and either select Append from the data preview window:

Or hit + Add transformation option from the left sidebar, then select Append:

2. Choose the sources you want to stitch and select the "Append data" option. You may append data from all the sources you added in your importer, or pick only specific sources:

3. The appended data will appear under the dedicated section on the left sidebar:

4. Preview the appended data, and make further transformations, if needed. Keep in mind that Append mode stitches data from all selected sources under the same headers (column names), so you may want to adjust your column names to match, where applicable, to have the aligned dataset:

See more tips on Data transformation

5. If no further transformations are needed, proceed to the Destinations setup.

6. Add all needed settings for the destination.

7. Proceed to add the schedule.

8. Save and Run the importer to check the results of data stitching

If you have any questions, please write to our Support team!