This content has been marked as final. Show 2 replies
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.
Load * FROM
CROSSTABLE (Fieldlist, Value)
LOAD 1 as Dummy, *
where RecNo() =1;
drop Table TABLE;
DROP FIELDS Dummy, Value;