CrossTable question

Joaquin_Lazaro — Fri, 20 Nov 2015 09:01:06 GMT

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

Re: CrossTable question

sunny_talwar — Fri, 20 Nov 2015 09:03:31 GMT

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