topic Re: Loading from Empty Qvd in QlikView

Loading from Empty Qvd

didierodayo — Fri, 04 Aug 2017 03:10:45 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

Re: Loading from Empty Qvd

Anil_Babu_Samineni — Fri, 04 Aug 2017 04:15:18 GMT

What are you expecting to see when FieldList is Filter ???

Re: Loading from Empty Qvd

didierodayo — Fri, 04 Aug 2017 04:18:32 GMT

Hi Anil,

am just trying to create a table with my column FieldList that hold all the fields(columns) fro the qvd.

thanks

Re: Loading from Empty Qvd

Anil_Babu_Samineni — Fri, 04 Aug 2017 04:20:17 GMT

You said, your QVD is empty. How you are expecting? Does qvd has any structure of Fields with out records?

Re: Loading from Empty Qvd

Anil_Babu_Samineni — Fri, 04 Aug 2017 04:20:18 GMT

You said, your QVD is empty. How you are expecting? Does qvd has any structure of Fields with out records?

Re: Loading from Empty Qvd

Anil_Babu_Samineni — Fri, 04 Aug 2017 04:20:19 GMT

You said, your QVD is empty. How you are expecting? Does qvd has any structure of Fields with out records?

Re: Loading from Empty Qvd

didierodayo — Fri, 04 Aug 2017 04:22:17 GMT

I mean the qvd columns have no value

Re: Loading from Empty Qvd

Anil_Babu_Samineni — Fri, 04 Aug 2017 04:29:22 GMT

Sorry to bougher you replying 3 times. Fortunately, I can't delete because my actions are not working.

Try this?

tabFields:

CrossTable (FieldList, Value) LOAD 1,*

FROM

(qvd);

Where RecNo()=1;

DROP Fields '1', Value;

If not, Can you use something like Where 1 = 2;

Re: Loading from Empty Qvd

Kushal_Chawda — Fri, 04 Aug 2017 04:53:35 GMT

TABLE:

Load * FROM

(qvd);

FIELDS:

CROSSTABLE (Fieldlist, Value)

LOAD rowno() as Row,

Resident TABLE;

drop Table TABLE;

DROP FIELDS Row, Value;

Re: Loading from Empty Qvd

didierodayo — Fri, 04 Aug 2017 05:02:56 GMT

Thanks Guys. I will apply Kushal idea.