Hi all,
I have two sets of data which i wish to link together, the problem is that they come in different formats and I wish to map them together.
one set creates a display as follows:
| APP | 1.1 | 1.2 | 1.3 |
| a | 01/02/2008 | 01/02/2008 | 01/02/2008 |
| b | 02/02/2008 | 03/02/2008 | 04/02/2008 |
| c | 03/08/2009 | 03/08/2009 | 03/08/2009 |
In this view each column is a field, ie App, 1.1, 1.2, 1.3
In the second set of data we have the following:
| APP | Question | Date |
| a | 1.1 | 01/02/2008 |
| a | 1.2 | 01/02/2008 |
| a | 1.3 | 01/02/2008 |
| b | 1.1 | 02/02/2008 |
| b | 1.2 | 02/02/2008 |
| b | 1.3 | 02/02/2008 |
| c | 1.1 | 03/08/2009 |
| c | 1.2 | 03/08/2009 |
| c | 1.3 | 03/08/2009 |
So in this there are only 3 fields. This is the representation we want to have so we can have all the questions as one field. Is there a way through mapping we can change the initial data to the second format?
thanks
