Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Salvatore99a
Contributor
Contributor

Store Statement

Hello,

I was wondering if there is a difference between the following:

Store * from (tablename) into...

and 

Store (tablename) into... 

If there is a difference between them what is it and which one would result in greater optimization.

Thank you in advance!

1 Solution

Accepted Solutions
afbraga1
Creator
Creator

Hello Salvatore99a,

table1:
LOAD * Inline[
1,2
1,1
];

These 2 methods are the same since you are storing all table fields;

store * from table1 into xx.qvd(qvd);
store table1 into xy.qvd(qvd);

But if you do it like the method below you will only store a specific field.

store '2' from table1 into xx.qvd(qvd);

Best regards,

André Braga

View solution in original post

1 Reply
afbraga1
Creator
Creator

Hello Salvatore99a,

table1:
LOAD * Inline[
1,2
1,1
];

These 2 methods are the same since you are storing all table fields;

store * from table1 into xx.qvd(qvd);
store table1 into xy.qvd(qvd);

But if you do it like the method below you will only store a specific field.

store '2' from table1 into xx.qvd(qvd);

Best regards,

André Braga