2 Replies Latest reply: May 16, 2013 6:53 AM by Thorsten Schröder RSS

    Grouping/categorizing columns within script

    Thorsten Schröder

      Hello community,


      on the left side in the image you can see my Excel file. The database table is the same except that I don't have the "Category 1", "Category 2" column headers.
      I want to group these using Qlikview - see the small table on the right. So that I can select Category 1 and I only get Col1 to Col3 values.


      Can I group the different colums in the load stmt? Do I need to transform the colums to field values.


      Hope you can help me out here.

      Thank you.