Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try using CROSS TABLE option in script.
Hope this helps you.
Regards,
Jagan.