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.