Merge / Join types

Merge / Join types

Created by: Johann Du Toit

Modified on: Mon, 15 Jul, 2019 at 3:02 PM


There are 3 types of joins (or merging) that you can use to combine your reports in Wink Reports: inner, left and union. Wink finds all the columns in both reports which have the same names, and then match the rows to each other if all the values in these common columns are the same.


For instance if both reports have a "Date" and a "Customer Name" column, then the resulting report will merge the rows of both for each unique matching combination of "Date" and "Customer Name".


Join TypeDescription
InnerWhen you use an inner join to combine reports, the result is a table that contains columns that have matches in both reports.

Left

When you use a left join to combine reports, the result is a table that contains all values from the left report and corresponding matches from the right one.


When a value in the left table doesn't have a corresponding match in the right table, you see a null or empty value in the merged report.


UnionUnion is another method for combining two or more reports by appending rows of data from one table to another vertically. Ideally, the reports that you union have the same number of columns, and those columns have matching names and data types.




What Is the Difference Between a Join and Union?

Joins and Unions can be used to combine data from one or more reports. The difference lies in how the data is combined.

In simple terms, joins combine data into new columns. If two reports are joined together, then the data from the first report is shown in one set of columns alongside the second reports’s columns in the same row.


Unions combine data into new rows. If two reports are “unioned” together, then the data from the first report is in one set of rows, and the data from the second report in another set. The rows are in the same result.


Here is a visual depiction of a join. Table A and B’s columns are combined into a single result.

Use Joins to Combine Columns

Joins Combine Columns


Each row in the result contains columns from BOTH table A and B. Rows are created when columns from one table match columns from another. Wink uses all columns with the same title to match on.


This makes joins really great for looking up values and including them in results.


Now compare the above depiction with that of a union. In a union each row within the result is from one report OR the other. In a union, columns aren’t combined to create results, rows are combined.

Use a union to combine rows

Unions Combine Rows


Unions are typically used where you have two reports whose rows you want to include in the same result. A use case may be that you have two reports: Employees and Contractors. You would like to create a master list of names and hours worked sorted by date.


To do this you can use a union to first combine the rows into a single result and then sort them.

    • Related Articles

    • What types of URLs does the File Import connector support?

      What types of URLs does the File Import connector support? The File Import connector supports http:// and https:// URLs which link directly to the file. It also supports Dropbox files Google Sheets To create the Dropbox link to import into Wink Sign ...
    • Merging Reports

      Created by: Johann Du Toit Modified on: Tue, 3 Dec, 2019 at 12:45 PM This tutorial will give a quick overview of how you can merge multiple reports and data sources into a single report. Note: This functionality is only available on Professional and ...
    • How to invite new users to Wink Reports

      Created by: Andrei Gromek Modified on: Fri, 11 May, 2018 at 1:23 PM Outline Wink Reports allows users to add additional users to organisations. Follow these steps to add a new user. 1. Select Organisations from the Wink Reports ;) menu Then select ...
    • Report Designer Formula Reference

      There are two places where formulas can be used in the report designer tool: Row Filter formula for reports Value Source formula for cells Both have the same syntax, but are used in different ways. The general formula language is inspired by the ...
    • Learn Regex The Easy Way

      What is a Regular Expression? A regular expression is a group of characters or symbols which is used to find a specific pattern in a text. A regular expression is a pattern that is matched against a subject string from left to right. Regular ...