Mapping of Values

Thu, 28 Mar 2013 05:56:41 GMT

Hi All,

I wan to map two column values from 2 different table like below, (Both table are linked using key 1). Column 1 is having Main Problem and Column 2 is having different root cause for the problem.

Table 1	Table 2
Column 1	Column 2
91	91 01
	91 02
	91 03
	91 04
	91 05
	91 06
	91 07
	91 08
	91 09
92	92 01
	92 02
	92 03
	92 04
	92 05
	92 06
	92 07
	92 08
	92 09
	92 10
	92 11
	92 12
	92 13
	92 14

Actually i'm getting value like this,

Table 1
Column 1
0
91
92
93
94
95
96
97
98

Table 2
Column 2
92 **
91 01
91 02
91 03
91 04
91 05
91 06
91 07
91 08
91 09
92 01
92 02
92 03
92 04
92 05
92 06
92 07
92 08
92 09
92 10
92 11
92 12
92 13
92 14

Thanks,

Selva

topic Mapping of Values in QlikView

Mapping of Values