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



      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.