Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

wenkew186
Contributor

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
Highlighted
Partner
Partner

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.

Thanks,

Arvind Patil