All fields from table - auto load

raju_salmon — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a master QVDs with incremental where new fields are added frequently. While creating this qvd, i have to take all fields and i am taking below code

Test:

SQL Select * from table;

Store Test into Test.qvd;

However while using Load statement how can i take all fields to concatenate with incremental load?

Does Load * from QVD works?

Re: All fields from table - auto load

Gysbert_Wassenaar — Wed, 21 Dec 2016 09:58:02 GMT

Yes, a Load also supports the *. So you can add something like

CONCATENATE (Test)

LOAD * FROM Test.qvd (qvd);

topic All fields from table - auto load in QlikView

All fields from table - auto load

Re: All fields from table - auto load