topic loading fields from empty qvd in App Development

loading fields from empty qvd

didierodayo — Fri, 04 Aug 2017 02:33:09 GMT

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 — Fri, 04 Aug 2017 04:59:28 GMT

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

arvind_patil — Fri, 04 Aug 2017 05:22:43 GMT

Hi didier,

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

Thanks,

Arvind Patil