Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1 | ||||
Company | Level 1 | Level 2 | Level 3 | Value |
AA | Manager | IT Lead | IT Staff | 5 |
AA | CIO | Dev Lead | Dev Staff | 3 |
AB | Manager | IT Lead | IT Staff | 2 |
AB | CIO | Dev Lead | Dev Staff | 1 |
Table 2 | ||||
Company | Level 1 | Level 2 | Level 3 | Value |
AA | Manager | IT Lead | IT Staff | 6 |
AA | CIO | Dev Lead | Dev Staff | 1 |
AB | Manager | IT Lead | IT Staff | 1 |
AB | CIO | Dev Lead | Dev Staff | 5 |
I want to join both tables and sum the values column.
If you load two tables with identical field names they will become one table and the second table will append the first, so you totals should work automatically.
when I load two tables with similar names I'm getting something like this
Company | Level 1 | Level 2 | Level 3 | Value |
AA | Manager | IT Lead | IT Staff | 5 |
AA | CIO | Dev Lead | Dev Staff | 3 |
AB | Manager | IT Lead | IT Staff | 2 |
AB | CIO | Dev Lead | Dev Staff |
1
|
AA | Manager | IT Lead | IT Staff | 6 |
AA | CIO | Dev Lead | Dev Staff | 1 |
AB | Manager | IT Lead | IT Staff | 1 |
AB | CIO | Dev Lead | Dev Staff | 5 |
Is that what you want ? When you sum the Value you should get what you want.
i want the values to be added