0 Replies Latest reply: Jul 8, 2014 9:27 AM by Calle Söderblom RSS

    CrossTable, only getting distinct values

      Hi,

       

      I have a question regarding a CrossTable load :

       

      Below is the query I have set up to collect the results...

       

      But I only get the distinct answer values back when I try to present them!?

       

      Surveys:

      CrossTable(Question, Answer,3)

      LOAD 

      SchoolName,

      Year,

      classname,

      [7915 Do you work ...?],

      [7918 How many years ...?],

      [7919 What is your first / native language?]

       

      FROM

      [..StaffSurveys.qvd]

      (qvd);

       

      fSurveys1:

      LOAD

      SchoolName,

      Question,

      Answer

      Resident Surveys;

      Drop table Surveys;


      The result should look like this :

                                     [7915 Do you work ...?]          [7918 How many years ...?]          [7919 What is your first / native language?]                   

      School1                              YES                                             5                                             Swedish

      School1                              YES                                                 6                                            Swedish

      School1                              YES                                                 5                                             Swedish

      School1                              NO                                                  5                                             English

      School1                             NO                                                  4                                             English

      School2                              YES                                                  2                                             English

      School2                                NO                                                  2                                             English

      School2                                NO                                                  3                                             English



      Any ideas would be much appreciated!


      Thanks in a bunch!


      Calle