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

    Selecting/Load specific Data from a Column

    Salamon Musayev





      I have a table with several columns.

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


      Column A








      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.