Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please, try to use crosstable to obtain what you want.
Kind regards,
Janusz