CrossTable question

[Joaquin_Lazaro]

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

[sunny_talwar]

Like you said, I usually do it in the next resident load and not sure if there is another way.