Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


remove col and row in cross table of wizard

hi expert,

I have a question want study from you.

when we load data from a excel table. I don't need all column to qvw file, there have a 2 method for my understand.

first, remove column by transformation step in "File wizard"; second, just keep useful column name in load script.

what's the different or not? my focus on if well impact memory in qvw or load efficiency.

thanks a lot!

1 Reply

Re: remove col and row in cross table of wizard

Hi Kevin,

If  you take required columns  then it will improve your performance because its in memory tool.  Its Store your all data  on server memory means less data less memory.


Arvind Patil