5 Replies Latest reply: Mar 19, 2012 12:12 PM by jonahall RSS

    Load field containg numbers as matrix with numbers as fieldnames

      I have a matrix of Time and client-IDs.

       

      Load * inline [Time, ID

      01,1

      02,12

      03,245

      03,123

      04,245

      06,174

      06,123

      07,12];

       

      And would like to load this sparse matrix:

       

      Time     1     12       123      174     245

      01         1     0          0          0          0

      02         0     1          0          0          0

      03         0     0          0          1          1

      04         0     0          0          0          1

      06         0     0          1          1          0

      07         0     1          0          0          0

       

      How can I do this? Any ideas?

       

      Best,

      Jonas