Item property in several column

[#1]

Hello,

Can help me. I have 2 table:

1-Item (field Item No_),

Item No_

A1

A2

A3

A4

2-Item Property (Item No_,Property No_).

Item No_	Property No_
A1	P1
A2	P2
A3	P3
A4	P4
A2	P2
A2	P4
A3	P1
A3	P4
A4	P3

Fields look like in qlikview I want to see this:

Item No_	Property No_1	Property No_2	Property No_3	Property No_4
A1	P1	P2	P3	P4
A2	P2	P4	-	-
A3	P1	P3	-	-
A4	P3	-	-	-

Its like hierarchy , but not exactly

[jagan]

Hi,

Try using CROSS TABLE option in script.

Hope this helps you.

Regards,

Jagan.