1 Reply Latest reply: Nov 20, 2015 4:03 AM by Sunny Talwar RSS

    CrossTable question

    Joaqu�n L�zaro

      Hello guys:

       

      I have this CrossTable and it works as expected

       

      File:

      CrossTable(LINE, DESCRIPCION, 1)

      LOAD CODAR, 

           DESC01, DESC02, DESC03, DESC04, DESC05, DESC06, DESC07, DESC08, DESC09, DESC10;

       

      Some of the fields DESC* could have no value

       

      Is there any way to create a CrossTable without the null or empty items ?

       

      Well, I would do it using two steps, but if there is an easy way, it will be a faster script.

       

      Thanks for your support.

      Joaquín