3 Replies Latest reply: Jun 7, 2017 11:16 AM by Marcus Sommer RSS

    Why is 'Qualify' statement multiplying the total record and column number in a 'Crosstable' statement?

    Julio Andrés Arriaga Rangel

      Hello everyone,

       

      Why is a 'Qualify' statement adding an extra column (tablename.tablename.date) multypling my total row number and altering the records' names in a 'Crosstable' statement?

       

      Thanks in advance.

       

      [Incorrect]

      Input:

      1. Qualify *; 
      2. Cross: 
      3. CrossTable(Country, Sales) 
      4. LOAD * INLINE [  0 as Input
      5. Date, USA, UK, Japan, Germany
      6. 2013-01-01, 123, 100, 80, 40
      7. 2013-02-01, 134, 111, 75, 50
      8. 2013-03-01, 155, 95, 70, 60
      9. 2013-04-01, 165, 85, 88, 50
      10. 2013-05-01, 154, 125, 90, 70
      11. 2013-06-01, 133, 110, 75, 99
      12. ];

      Output:

      Evidence1.PNG

       

       

      [Correct]

      Input:

      1. Unqualify *; 
      2. Cross: 
      3. CrossTable(Country, Sales) 
      4. LOAD * INLINE [  0 as Input
      5. Date, USA, UK, Japan, Germany
      6. 2013-01-01, 123, 100, 80, 40
      7. 2013-02-01, 134, 111, 75, 50
      8. 2013-03-01, 155, 95, 70, 60
      9. 2013-04-01, 165, 85, 88, 50
      10. 2013-05-01, 154, 125, 90, 70
      11. 2013-06-01, 133, 110, 75, 99
      12. ];

       

      Output:

      Evidence1.PNG