9 Replies Latest reply: May 22, 2015 11:39 AM by Ralph Nuesse RSS

    Splitting a table during load?

      Hi, I am quite new to Qlik (Sense) and am wondering if there is an easier way to "vertically" split a table.

      The situation I am in, is:

      I have got tables that contain data for several different products in different columns.

      colA1, ..., colAn, colB1, ..., colBn, colC1, ..., colC3,...

       

      Where colA1, ... contain data for product A

      Where colB1, ... contain data for product B

      and so on

       

      So in order to do some of my reporting I have split the tables like this

      LOAD

           columns for prod A

      WHERE

           columnA > 0

      ;

       

      LOAD

           columns for prod B

      WHERE

           columnB > 0

      ;

      ...

       

      Which results in the original table being read several times during load. Is there any known way to have the split in one go?

      Any suggestions or hints are appreciated

      Ralph