loading fields from empty qvd

[didierodayo]

Hello,

I am having some issue getting this concept to work, any suggestion is appreciated.

I have an empty qvd that is generated daily. I would like to get the list of fields from that empty QVD into a new field (Fieldlist).

the script below is returning nothing for field list.

TABLE:

Load * FROM

(qvd);

FIELDS: 

CROSSTABLE (Fieldlist, Value)

LOAD 1 as Dummy, * 

Resident TABLE

where RecNo() =1; 

drop Table TABLE;

DROP FIELDS Dummy, Value; 

thanks

[balar025]

Can you please share your expected output and sample data set?

[arvind_patil]

Hi didier,

If you provide sample data we will help you in more appropriate way.

Thanks,

Arvind Patil