Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

All fields from table - auto load

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

CONCATENATE (Test)

LOAD * FROM Test.qvd (qvd);


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

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

CONCATENATE (Test)

LOAD * FROM Test.qvd (qvd);


talk is cheap, supply exceeds demand