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.

      example.PNG

      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.