Qlikview - Variable that assume multiple values

[#1]

Hi experts,

Imagine that I've five (six with the ID) different fields on a Table:

A

B

C

D

E

ID

And I've another table that have a field that classifies this fields:
ID
NOTE1
NOTE2

Basically my fact tableis:
ID
A
B
C
D
E
NOTE1
NOTE2

How can I build a table like this:

Field	NOTE1	NOTE2
A
B
C
D
E

When I insert the multiple fields into Dimensions I'm getting like this

Field	B	C	D	E	NOTE1	NOTE2
A
B
C
D
E

Many thanks!

[sunny_talwar]

May be like this:

Table:

CrossTable(Field, Value)

LOAD ID,

           A,

           B,

           C,

           D,

           E

FROM...

Left Join (Table)

LOAD ID,

           Note1,

           Note2

FROM ...

[Or]

From your description, it isn't clear what the relation is, if any, between a specific value of A to a specific value of Note1 and Note2. How is your QlikView table supposed to tell which of the five columns (A-E) is the one associated with a specific note?