Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
FIELDS:
CROSSTABLE (Fieldlist, Value)
LOAD 1 as Dummy, *
Resident TABLE
where RecNo() =1;
drop Table TABLE;
DROP FIELDS Dummy, Value;
thanks
Can you please share your expected output and sample data set?
Hi didier,
If you provide sample data we will help you in more appropriate way.
Thanks,
Arvind Patil