Users of InetSoft's award-winning dashboard software can merge dashaboard data to create custom interactive reports across various industries. View the example below to learn more about the Style Intelligence solution.
The Merge Join is a special type of join that creates no relationship between the two base tables. The base tables are simply merged into a single table by collecting their columns together and placing corresponding rows side by side.
To create a merge join, follow these steps:
1. Select both tables by Ctrl-clicking on each table's title row.
2. Click the 'Join Table' button in the Worksheet toolbar, and select 'Merge Join'. A new merge-joined table is created.
In the merge-joined table, the columns of the shorter table are padded with empty rows to match the length of the longer table. The number of columns in the final merge-joined table is the sum of the columns in the two base tables.
| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index |
|
Read More |
For example, say we want to see all of the orders from the states of NY and NJ side by side. We can accomplish this by using the merge join.
1. Create a new Worksheet.
2. Expand the 'Query' node, the 'Orders' node, and the 'DWS' node.
3. Drag the 'NY Orders' node from the tree to an empty cell in the Worksheet. A new table named 'NY Orders1' is created.
4. Drag the 'NJ Orders' node from the tree to an empty cell in the Worksheet. A new table named 'NJ Orders1' is created.
5. Now select both the tables by holding down the Ctrl key and clicking on each table's title row.
6. Click on the 'Join Table' button on the top toolbar, and select 'Merge Join'. A new table, 'Query1' is created.
Notice that since the merge join does not have any relationship specified between the two tables, there is no connector line to the left of the table. The join type, therefore, can not be changed.
7. Preview the 'Query1' table by right-clicking on the title row and selecting 'Preview'. Notice that since the 'NJ Orders1' table has more rows than the 'NY Orders1' table, the number of rows of the 'Query1' table is equal to the number of rows of the 'NJ Orders1' table. Also notice that the 'NY Orders1' table has two empty rows appended to it.