mapping problem

Wed, 03 Feb 2010 13:05:27 GMT

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

mapping problem

Wed, 03 Feb 2010 13:54:41 GMT

Hi,

Please, try to use crosstable to obtain what you want.

Kind regards,

Janusz

topic mapping problem in QlikView

mapping problem

mapping problem