4 Replies Latest reply: Aug 22, 2018 5:10 PM by Ali Ahmad RSS

    Multiple join taking really long

    Vincent Bellanger

      Greetings,

       

      I've a table like this

      School:

      NameClassResult
      DiazEnglish12
      DiazFrench16
      DiazGerman17
      HoltEnglish11
      HoltFrench8
      HoltGerman9
      PeraltaEnglish15
      PeraltaFrench16
      PeraltaGerman20

       

      And i would like to change it to that way:

      Final:

      NameEnglishFrenchGerman
      Diaz121617
      Holt1189
      Peralta151620

       

      I'm doing it like this:

       

      Final:

      load Name

      resident School;

       

      left join (Final)

       

      LOAD Name,

      Class as English

      Resident School

      where "Class" = 'English';

       

      left join (Final)

       

      LOAD Name,

      Class as French

      Resident School

      where "Class" = 'French';

       

      left join (Final)

       

      LOAD Name,

      Class as German

      Resident School

      where "Class" = 'German';

       

       

      It work fine big i've a lot of data and if i try to add more classes (more join), it's taking suddenly a tremendous amount of time, sometimes crashing the qliksense engine, is there something i'm doing wrong like a loop i don't see or something ?

       

      Thanks for the answers!