2 Replies Latest reply on Sep 7, 2016 6:36 PM by Sherzodbek Ibragimov

    Combining two dimensions to get normalized data

    Sherzodbek Ibragimov

      I have two dimensions: level of study (Undergraduate, Graduate, Null [Unknown as alias]) and student type (Degree seeking, Non degree seeking, Transfer, International, First Time Freshman, First-time Freshman, First Time Graduate Student, Graduate Transfer, OLD, Null [Unknown as alias]). The problem is both of dimensions are incomplete and inconsistent, thus i can't use only one of the to get normalized 'level of study'. So, I am trying to to use both dimensions so I can come up with more accurate level of study with less unknows. Well, I have tried following formula, but doesn't seem to work. I should be have about 23k real unknowns per excel, but my result shows way more than that. Could you please direct me on that? I really appreciate that.

       

      IF [Student Type]='Degree Seeking' THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Graduate' and [Student Type]='First Time Freshman') THEN 'Graduate'
      ELSEIF ([Level of Study]= 'Undergraduate' and [Student Type]='First Time Freshman') THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Unknown' and [Student Type]='First Time Freshman') THEN 'Undergraduate'
      ELSEIF [Student Type]='First Time Graduate Student' THEN 'Graduate'
      ELSEIF [Student Type]='First-time Freshman' THEN 'Undergraduate'
      ELSEIF [Student Type]='Graduate Transfer' THEN 'Graduate'
      ELSEIF ([Level of Study]='Undergraduate' and [Student Type]='International') THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Graduate' and [Student Type]='International') THEN 'Graduate'
      ELSEIF ([Level of Study]='Unknown' and [Student Type]='International') THEN 'Undergraduate'
      ELSEIF [Student Type]='Non degree seeking' THEN 'Undergraduate'
      ELSEIF [Student Type]='OLD' THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Undergraduate' and [Student Type]='Transfer') THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Graduate' and [Student Type]='Transfer') THEN 'Graduate'
      ELSEIF ([Level of Study]='Unknown' and [Student Type]='Transfer') THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Undergraduate' and [Student Type]=NULL) THEN 'Undergraduate'
      ELSEIF ([Level of Study]='Graduate' and [Student Type]=NULL) THEN 'Graduate'
      ELSE 'Unknown' END