Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

didierodayo
Contributor III

loading fields from empty qvd

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

Tags (1)
2 Replies
balar025
Contributor III

Re: loading fields from empty qvd

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

arvind_patil
Valued Contributor II

Re: loading fields from empty qvd

Hi didier,

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

Thanks,

Arvind Patil