5 Replies Latest reply: Aug 27, 2016 9:29 AM by Sunny Talwar RSS

    Selecting/Load specific Data from a Column

    Salamon Musayev

      Hi

       

       

       

      I have a table with several columns.

      A specific column has 10 fields of which I need only 3.

       

      Column A

      'a'

      'b'

      'c'

      -

      -

      'k'

       

      I am trying to load specific fields from a column instead of loading all of them.

      For example in SQL, I would use,

       

      Select *

      From xxxxxxx

      Where Column A IN ( 'a' or 'b' or 'c')

       

      How can I do the same in QLik sense load editor.  Either filter out the column or a create a new column with only those fields.

      (The actual number of columns and field is much larger than provided in the example.)

       

      Please help.