5 Replies Latest reply on Jul 3, 2018 6:58 AM by Shinichiro Murakami

    text table on multiple columns

    Peter Harangozo

      Hi

       

      I have a big data set having 100 000s of rows, part of that is 12 column, containing a monthly measurement of stg, lets say having value between 0 and 100.

      Can I create a table, having the columns are the months, and having 101 rows from 0...100, and the fields filled with the frequency values.

       

      so for example if January column there are 233 fields filled with 0, and 172 filled with 1, I want something like this:

       

      frequency , jan, feb, mar, ....

      0 : 233 , x, y, ....

      1 : 172, w, v, ....

       

       

      For 1 column it is easy, just have to create bins on the column, and make a count on them, but I can't figure out how to create common bins on multiple (that case 12) columns (or probably it should be done on a way different method)

       

       

      original table
      usersjanfebmar
      a113
      b213
      c313
      d413
      e514
      f614
      g714
      h814
      j915
      k115
      l225
      m325
      n426
      o526
      p626
      q726

       

       

      what I want to see as a summary table
      valuejanfebmar
      12100
      2270
      3204
      4204
      5204
      6204
      7200
      8100
      9100