When using Sheetgo you have two possible ways of merging data from multiple files into a single one. The first one is the Merge option, which will use the header as a guide and add all the data below it, filling the rows of the spreadsheet. But there's also a second way of merging data, which is called Left Join.
With this data processor, instead of using the header as a guide, it will use a column, and all the information will be added side by side.
To use this feature your spreadsheet must have a column with unique values that will be used as a reference to connect the data
What does the left join feature do?
The left join process allows you to merge data from spreadsheets horizontally, it has a similar behavior to the SQL join function, which means that it will connect the data from two or more spreadsheets using the unique values as a guide. All spreadsheets that you are joining should have a column with the same unique values, although they don't have to be in the same order.
In the example below we will use column A (name) as the join column, which means that it needs to be present on all the spreadsheets we will join.
How to set up the left-join
1. Open Sheetgo’s web app, click New workflow, and Create a connection
2. Select multiple files
3. Select the files you will use
If your files have more than one tab, make sure you've selected the right ones to join.
4. Select the Left join process
5. Select the join column
From the dropdown menu choose which column will be used as reference for the join process. Remember that the column needs to be present on all spreadsheets and have unique values on it.
The dropdown menu will show the name of the column as it appears on the first spreadsheet that was selected for the join process. If any data is not present in the column of the first spreadsheet, this information will not be transferred to the destination spreadsheet.
6. Select the destination spreadsheet
You can send your data to a single spreadsheet or multiple files. In our case, we are sending the data into one Google Sheet spreadsheet.
From here, you can either select an existing spreadsheet or create a new one as a destination. By default, Sheetgo will save a new spreadsheet on the root folder of the source documents. If you are creating a new spreadsheet, you must give it a name. Sheetgo will join all the data from the source files into a single tab. When you're done click Finish and save.
After the join process is completed you will have all the columns from your spreadsheet side by side on a new spreadsheet. In this example, our source files had three columns each, with Column A (name) being the join column. The destination spreadsheet has 5 columns joining the data from both source spreadsheets.
Please note! Although the spreadsheets had the same number of values, each one had a different value from each other. Spreadsheet 1 had Thomas and 2 had Francine, since the values from Spreadsheet 1 are the guide for the join process Thomas is transferred to the destination file, but Francine is not.
And since Thomas doesn't have a reference on the second spreadsheet he doesn't have data populate to columns D and E.