3 Replies Latest reply: Nov 15, 2010 10:37 AM by Miguel Angel Baeyens de Arce RSS

    How to select values from two columns to one output column

      hi friend,

      I have database table with following structure and data:
      colX colY colZ
      1 A B
      2 A C
      3 A D
      4 A B
      5 B A
      6 B C
      7 B D
      8 B E
      9 C B
      10 C D
      11 C E
      12 D B
      13 D A
      14 E B
      15 A E
      16 D B
      17 C B
      18 C A
      19 C B
      20 B C
      and I would want output in next form:
      colX colQ
      1 A
      2 A
      3 A
      4 A
      5 A
      13 A
      15 A
      18 A
      means to select all rows where colY="A" or colZ="A" and display value "A" in new column "Q"

      How can I create load in script with that functionality in QlikView???

      Then I want put table object with fields "colX", "colQ".