bertusavius
Board Regular
- Joined
- Feb 28, 2008
- Messages
- 82
I have two tables
TableA
<TBODY>
</TBODY>
of which I generate this pivot table:
<TBODY>
</TBODY>
also tableB
<TBODY>
</TBODY>
Now I'd like to combine the two by creating a relationship between the two key columns above.
What I'd like to see is this:
<TBODY>
</TBODY>
but what I get is this:
<TBODY>
</TBODY>
How could I relate those two values correctly?
TableA
name</SPAN> | date</SPAN> | property2</SPAN> | key</SPAN> |
eventa</SPAN> | 1-1-2012</SPAN> | xxx</SPAN> | 1-1-2012xxx</SPAN> |
eventb</SPAN> | 2-5-2012</SPAN> | yyy</SPAN> | 2-5-2012yyy</SPAN> |
eventc</SPAN> | 2-5-2012</SPAN> | yyy</SPAN> | 2-5-2012yyy</SPAN> |
<TBODY>
</TBODY>
of which I generate this pivot table:
1-1-2012 | |
xxx | 1 |
yyy | |
2-5-2012 | |
xxx | |
yyy | 2 |
<TBODY>
</TBODY>
also tableB
name | date | property2 | value | key(unique) |
action1 | 1-1-2012 | xxx | 99 | 1-1-2012xxx |
action2 | 2-5-2012 | yyy | 55 | 2-5-2012yyy |
<TBODY>
</TBODY>
Now I'd like to combine the two by creating a relationship between the two key columns above.
What I'd like to see is this:
1-1-2012 | ||
xxx | 1 | 99 |
yyy | ||
2-5-2012 | ||
xxx | ||
yyy | 2 | 55 |
<TBODY>
</TBODY>
but what I get is this:
1-1-2012 | ||
xxx | 1 | 99 |
yyy | 99 | |
2-5-2012 | ||
xxx | 99 | |
yyy | 2 | 99 |
<TBODY>
</TBODY>
How could I relate those two values correctly?